Pomelo Lee workspace

MySQL表类型和存储引擎的修改遭遇版本不一致

星期五, 2014-07-25 | Author: LeecloseAuthor: Lee Name: lee
Email: [email protected]
Site: https://www.pomelolee.com/
About: webgame网页,手机游戏服务端架构和开发者See Authors Posts (492) | Database, JAVA-and-J2EE | 3,244 views

使用的是老版本的mysql客户端Navicate 8 ，mysql 服务端用的是mysql5.6的版本，在修改版本引擎的时候出现版本不对;

mysql error ‘TYPE=MyISAM’

解决办法：
Replace

TYPE=MyISAM

with

ENGINE=MyISAM

The problem was “TYPE=MyISAM” which should be “ENGINE=MyISAM” as per MySQL version updates – a simple search / replace has fix it.

附 修改表引擎sql：alter table db.user engine =MyISAM;

~谢谢打赏~

赏

Tags: mysql, mysql5.5

No comments yet.

Leave a comment