mysql中show常用語句 查看引擎: show engines\G 看某一個表的存儲引擎,就是看該表的創建過程 show create table [tb_name]\G show table status like '[tb_name]'\G; select table_name,engine from tables where table_name='[tb_name]' and table_schema='[db_name]'\G --修改存儲引擎: alter table city engine=MyISAM;