ALTER TABLE tablename ENGINE=MYISAM;
ALTER TABLE tablename ENGINE=INNODB;
-----------------------------------------------
alter table test engine = myisam;
show create table ***;
alter table 表名 modify column 字段名 类型;
ALTER TABLE tablename ENGINE=INNODB;
-----------------------------------------------
alter table test engine = myisam;
show create table ***;
alter table 表名 modify column 字段名 类型;