Select CONCAT( 'drop table ', table_name, ';' )
FROM information_schema.tables
Where table_name LIKE 'hn_%';
批量删除指定前缀的数据库表
最新推荐文章于 2025-06-07 19:39:36 发布
Select CONCAT( 'drop table ', table_name, ';' )
FROM information_schema.tables
Where table_name LIKE 'hn_%';