...

View Full Version : SQL error



amcf1992
02-05-2013, 10:46 PM
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;

Old Pedant
02-05-2013, 11:35 PM
TYPE= is wrong. It should be ENGINE=



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum