任务:需要删除某一数据库内所有以数字开头的表格。
命令如下:
mysql> SELECT concat("drop tables ",group_concat(TABLE_NAME), ';') AS statement FROM information_schema.TABLES WHERE TABLE_SCHEMA="test" AND TABLE_NAME REGEXP '^[0-9]'; +------------------------------+ | statement | +------------------------------+ | DROP TABLES 123_abc,123_cdf; | +------------------------------+ 1 ROW IN SET (0.00 sec) mysql> DROP TABLES 123_abc,123_cdf; Query OK, 0 ROWS affected (0.00 sec) |