MYSQL--批量数据库中的删除表
1、如果不要数据库中的所有表:
drop database database_name;
create database database_name;
2、比较麻烦的做法:
mysql> select concat('drop table ',table_name) from tables where TABLE_SCHEMA='test';
+----------------------------------+
| concat('drop table ',table_name) |
+----------------------------------+
| drop table a |
| drop table c |
| drop table mrg |
| drop table t |
| drop table t1 |
| drop table t2 |
| drop table temp_udf |
| drop table user |
+----------------------------------+
8 rows in set (0.00 sec)
或者
mysql> select concat('drop table ',table_name) from tables where TABLE_SCHEMA='test' into outfile 'd:\drop.sql';
Query OK, 8 rows affected (0.00 sec)
查看drop.sql
转载于:https://blog.51cto.com/shouhouzhe/1376815