You have an error MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 20

ERROR 1064 (42000): 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=InnoDB' at line 20

ERROR 1064 (42000): 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 14

解决办法：

将"TYPE=InnoDB" 替换为"ENGINE=InnoDB" 

将"TYPE=MyISAM" 替换为"ENGINE=MyISAM" 

linux 的vi 里面执行命令：

:.,$s/TYPE=InnoDB/ENGINE=InnoDB/g

:.,$s/TYPE=MyISAM/ENGINE=MyISAM/g

参考：http://stackoverflow.com/questions/16408334/how-do-i-fix-error-in-your-sql-syntax-check-the-manual-for-the-right-synta