mysql删除相同的表前缀

2023-12-01 PM08:27:51


SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) 
    AS statement FROM information_schema.tables 
    WHERE table_schema = 'Table' AND table_name LIKE 'prefix_%';

.....

转载请注明：谷谷点程序 » mysql删除相同的表前缀