Mysql Erase Data

1. Delete and Truncate differences:

The TRUNCATE TABLE command quickly deletes all records in the datasheet, but retains the data table structure.

This quick delete is not the same as deleting all the data table records in the delete from data table, the deleted data is stored in the system rollback segment, the data can be rolled back for recovery when needed, and the data deleted by the TRUNCATE command is not recoverable.

2, if there are foreign key constraints between the tables, emptying the data table needs to first ignore the foreign key, delete the data, and then restore the foreign key;

The SQL commands executed are:

1 SET foreign_key_checks=0;
2 truncate TABLE tablename;
3 SET foreign_key_checks=1;

Mysql Erase Data