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 http://bugs.mysql.com/bug.php?id=17501

 

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>