SQL Help

[Macemore]

So I'm trying to run this file in my database:

#
# Table structure for table 'members'
#
 
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;
 
 
 
#
# Dumping data for table 'members'
#
 
INSERT INTO `members` (`member_id`, `firstname`, `lastname`, `login`, `passwd`) VALUES("1", "Jatinder", "Thind", "phpsense", "ba018360fc26e0cc2e929b8e071f052d");

And I get an 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' at line 12

Help please?

 

[Sledmur]

Change

TYPE=MyISAM

To

ENGINE = MYISAM

 

[Macemore]

Change

TYPE=MyISAM

To

ENGINE = MYISAM

Thanks, that worked!

Moderator please close le thread
@m0nsta.