MySQL Erase data

There are 2 commands to clear the data

• -- 清空全部数据，不写日志，不可恢复，速度极快truncatetable表名;
• -- 清空全部数据，写日志，数据可恢复，速度慢deletefrom表名

Business requirements: Clear all test data, leaving only empty data tables

1. Querying all table names in the database

Select table_name
From Information_schema.tables
where table_schema= ' database to query '

2, execute script (traverse execution, suitable for a few test data, large amount of data need to add limit to avoid the table is locked)

deletefrom表名 

MySQL Erase data