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`)
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
Thanks in advance,
the code works fine on my mysql, what version of mysql are you using?
change TYPE=MyISAM to ENGINE=MyISAM
Thank you very much, that seemed to do the trick.
Originally Posted by r937