1 2 3 | SELECT CONCAT('ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' DROP FOREIGN KEY ',CONSTRAINT_NAME,' ;')FROM information_schema.TABLE_CONSTRAINTS cWHERE c.TABLE_SCHEMA='wcp' AND c.CONSTRAINT_TYPE='FOREIGN KEY'; |
之后复制到文档里,就可以执行了!
1 | select CONCAT('alter table ',table_name,' engine=MyISAM;') FROM information_schema.tables WHERE table_schema="wcp" AND ENGINE="INNODB"; |
之后复制到文档里,就可以执行了!
PNG