MySQL 用 tdelete 命令快速清空一个数据库中的所有表。
1. 先执行select语句生成所有truncate语句
语句格式:
select CONCAT('truncate TABLE ',table_schema,'.',TABLE_NAME, ';') from INFORMATION_SCHEMA.TABLES where table_schema in ('数据库1','数据库2');
以名为dbname的数据库为例,执行select语句:
mysql> select CONCAT('DELETE FROM ',table_schema,'.',TABLE_NAME, ';') from INFORMATION_SCHEMA.TABLES where table_schema in ('dbname');
执行结果
DELETE FROM cb_loan_batch.cb_batch_data_center;
DELETE FROM cb_loan_batch.cb_batch_globe_control;
DELETE FROM cb_loan_batch.cb_batch_job_config;
2.执行完sql后会有相应的库名 比如 DELETE FROM cb_loan_batch.cb_batch_data_center;
其中 cb_loan_batch.cb_batch_data_center; cb_loan_batch 是库名cb_batch_data_center是表名
只需打开工具将库名替换掉就可以了