方法1:重建库和表
用mysqldump --no-data把建表SQL导出来,然后drop database再create database,执行一下导出的SQL文件;
方法2:生成清空所有表的SQL
select CONCAT(‘TRUNCATE TABLE ‘,table_name,’;’) from information_schema.tables where TABLE_SCHEMA = ‘db1’
导出到文件
select CONCAT(‘TRUNCATE TABLE ‘,table_name,’;’) into outfile ‘/website/truncatetable.sql’ from information_schema.tables where TABLE_SCHEMA = ‘db1’
查询数据库中有多少表
SELECT COUNT(*) TABLES, table_schema FROM information_schema.TABLES WHERE table_schema = ‘k3_ba’