Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: SQL error
02-05-2013, 11:46 PM #1
- Join Date
- Jul 2011
- Thanked 0 Times in 0 Posts
Here is my SQL create query, im getting a MySQL syntax error at line 8
CREATE TABLE `members` ( `member_id` int(11) unsigned NOT NULL auto_increment, `firstname` varchar(100) default NULL, `lastname` varchar(100) default NULL, `login` varchar(100) NOT NULL default '', `passwd` varchar(32) NOT NULL default '', PRIMARY KEY (`member_id`) ) TYPE= MyISAM;
Last edited by amcf1992; 02-05-2013 at 11:48 PM.
02-06-2013, 12:35 AM #2
TYPE= is wrong. It should be ENGINE=
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.