#1064!

Databases
1

I need some help with code.

CREATE TABLE iTracker (
id int(6) NOT NULL auto_increment,
serial text NOT NULL default ‘’,
name1 text NOT NULL default ‘’,
name2 text NOT NULL default ‘’,
ip text NOT NULL default ‘’,
time text NOT NULL default ‘’,
PRIMARY KEY (id),
UNIQUE KEY id (id)
)TYPE=MyISAM AUTO_INCREMENT=1;

That is my code, and I am getting this error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘TYPE=MyISAM AUTO_INCREMENT=1’ at line 10

Please help!

Thanks in advance,

Charlie

2

the code works fine on my mysql, what version of mysql are you using?

3

change TYPE=MyISAM to ENGINE=MyISAM

4

Thank you very much, that seemed to do the trick.