Select Page

If you experienced this kind of problem when doing database stuff

#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’

Here is a quick fix for that

you must change this

  TYPE=MyISAM

to

 ENGINE=MyISAM

TYPE was deprecated in MySQL 4.0 and removed in MySQL 5.5.

And it should work like a charm.

Pin It on Pinterest

Share This