SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) AS statement FROM information_schema.tables WHERE table_schema = 'video' AND table_name LIKE 't_c%';
SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) AS statement FROM information_schema.tables WHERE table_schema = 'video' AND table_name LIKE 't_c%';
转载于:https://www.cnblogs.com/liadmin/p/6360978.html