MySQL error: MySQL server version for the right syntax-use near ' type=innodb '

When building a table with SQL statements at work, MySQL reported the following error:

You have a error in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-use-near ' Type=innodb ' on line 1

Solution:

This error is due to some versions of MySQL does not support the type notation, the type keyword to the engine can be changed.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

MySQL error: MySQL server version for the right syntax-use near ' type=innodb '