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