mysql - 删除数据库中的数据，但是表结构保留

Question

mysql如何捉到，删除数据库中的数据，但是表结构保留
每个表都清空数据，但是各个表的字段都保留。
请问有20个表的话，就必须把说有的表名引用一遍？
写20遍？
delete from tablename1；
delete from tablename20；

Answer 1

<?php
//用循环执行SQL,瞬间帮帮你删除干净了,即使是100张表 也是瞬间
for($i=0;$i<=20;$i++)
{
    $sql = 'DELETE FROM tableName'.$i;
    $db->query($sql);
}

Answer 2

Run this statement and it will generate all table deletion statements for the specified database. Just take the result query and be sure to replace your database name

SELECT Group_concat(a.sql_truncate, a.sql_truncate, '') AS sql_truncate 
FROM   (SELECT Concat('truncate table ', table_name, ';') AS sql_truncate 
        FROM   information_schema.tables 
        WHERE  table_schema = '你的数据库名' 
               AND table_type = 'BASE TABLE') AS a 

truncate table table_name

Answer 3

mysql -uroot test -e "show tables" > all_table.md
然后用vim或者sublime编辑all_table.md在前面统一加上delete from 

Answer 4

Write stored procedure
Read table name and execute delete in loop
delete from tablename;

Answer 5

Export the table structure and delete the database. Rebuild

Answer 6

drop user username cascade
Cascade delete all data under the user

Answer 7

Don’t use delete, use truncate