SELECT CONCAT('drop table ', table_name, ';')
FROM information_schema. TABLES
WHERE table_name LIKE 'ooo%';
mysql 批量删除以某某开头的表或视图
最新推荐文章于 2024-05-08 17:18:18 发布
SELECT CONCAT('drop table ', table_name, ';')
FROM information_schema. TABLES
WHERE table_name LIKE 'ooo%';