- a developer's blog

MySQL error with ‘TYPE=MyISAM’

Just a quick note:

MySQL has deprecated the use of the keyword ‘TYPE’ to define the database engine. The database engine is now defined using the syntax engine.

So if you are using a script which still uses this keyword, you will get an error message like:

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 11.

To correct this error, simply replace your engine definition from TYPE=MyISAM to ENGINE=MyISAM.

So now you would define a table like this:

 CREATE TABLE `mytable` (
		  `post_id` int(10) unsigned NOT NULL auto_increment,
		  `title` varchar(255) NOT NULL default '',
		  `desc` text NOT NULL,
		  `comments` text NOT NULL,
		  PRIMARY KEY  (`post_id`),
		  KEY `word_title` (`word_title`(5)),
		  FULLTEXT KEY `word_desc` (`word_desc`)