MySQL TYPE=MyISAM deprecated

The TYPE keyword does not work in the latest versions of MySQL any more (e.g. MySQL 5.5). If your application uses it you will receive a statement like

#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

The solution is to replace TYPE=MyISAM by ENGINE=MyISAM (or TYPE=InnoDB by ENGINE=InnoDB).

Further information can be found at


Leave a Reply

Your email address will not be published.