CodingForums.com - SQL error

CodingForums.com (http://www.codingforums.com/index.php)

- MySQL (http://www.codingforums.com/forumdisplay.php?f=7)

- - SQL error (http://www.codingforums.com/showthread.php?t=287128)

amcf1992

02-05-2013 10:46 PM

SQL error

Here is my SQL create query, im getting a MySQL syntax error at line 8

Code:

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=

All times are GMT +1. The time now is 12:26 AM.