批量删除表

SELECT CONCAT( 'DROP TABLE `', `TABLE_NAME`,'`;' )FROM `information_schema`.`TABLES` WHERE `TABLE_NAME` LIKE 'mtsfk_addon%' AND `TABLE_SCHEMA` ='oa_cxy163_net';

批量更改表前缀

SELECT CONCAT( 'ALTER TABLE `', `TABLE_NAME`,'` RENAME TO `',replace(`TABLE_NAME`,'dede_','new_'),'`;' )FROM `information_schema`.`TABLES` WHERE `TABLE_NAME` LIKE 'mtsfk_addon%' AND `TABLE_SCHEMA` ='oa_cxy163_net';

UPDATE `foot_channeltype` SET `maintable`=REPLACE(`maintable`,'dede_','foot_'),`addtable`=REPLACE(`addtable`,'dede_','foot_');

打赏

微信扫一扫，打赏作者吧～

本文固定链接: https://www.cxy163.net/archives/1026 | 绝缘体