引擎

# 查询库里面的表引擎
SELECT CONCAT( 'ALTER TABLE ', TABLE_NAME, ' ENGINE=INNODB;' )
FROM information_schema.tables
WHERE table_schema = 'crmdb' and ENGINE='MyISAM'
# 修改引擎
ALTER TABLE t_mt_index_trades ENGINE=INNODB;
# 若更新失败
ALTER TABLE t_earnest_dealer_fee ROW_FORMAT = DEFAULT;