Error 1064 Mind Boggler

[FreakingOUT]

(On ISP's Server)

MySQL  Version 5.5.14

PHP Version 5.2.17

 

I spent over an hour trying to figure out why this very simple sample code from an article keeps yielding an Error 1064 message.  Now my eyeballs are rolling and I am Freaking OUT ;-(

 

CREATE TABLE employee (
id smallint(5) unsigned NOT NULL,
firstname varchar(30),
lastname varchar(30),
birthdate date,
PRIMARY KEY (id),
KEY idx_lastname (lastname)
) ENGINE=InnoDB;

 

I even  deleted the KEY idx_lastname (lastname) line but that didn't work ;-(

 

My repeated attempts were using both PHPMyAdmin and MyQSL Workbench.

 

What am I missing???

 

Thanks very much for any insight(s).

 

- FreakingOUT

 

[FreakingOUT]

This is just too weird. 

 

I turned everything off and went to bed disillusioned.  Woke up at 3AM and decided to try again, this time copy & pasting the same exact code from my posting and FINALLY the test TABLE was created.

 

Perhaps there is a glitch in my ISP's installation.

 

Sorry for the bandwidth.

 

-FreakingOUT