mysql> drop table like 'qibo_%';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'like 'qibo_%'' at line 1
mysql> show tables where table_name like 'qb_%';
ERROR 1054 (42S22): Unknown column 'table_name' in 'where clause'
mysql> select concat('drop table ', TABLE_NAME, ';') from information_schema.`tables` where TABLE_NAME like 'qb_%';
+----------------------------------------+
| concat('drop table ', TABLE_NAME, ';') |
+----------------------------------------+
| drop table qb_ad_compete_place; |
| drop table qb_ad_compete_user; |
| drop table qb_ad_config; |
| drop table qb_ad_norm_place; |
...
+----------------------------------------+
156 rows in set (0.03 sec)
mysql批量删除表名为某前缀的表
最新推荐文章于 2024-07-14 02:04:32 发布