MySQL TRUNCATE TABLE command Usage Summary

Truncate use note due to the TRUNCATE TABLE a_table command once, take the lesson and record it as a warning!  MySQL TRUNCATE TABLE a_table command affected result description, hands-on experience command TRUNCATE TABLE a_table; The data in the execution table is deleted and the increment ID value is emptied, but the index and table fields do not change. Remember to change the value of the growth ID!   Be careful when you use it! truncate performance truncate TABLE (InnoDB engine) number 1700w (17708030), 27s only, average 63w mysql> truncate table dzh_weibo_ per second cache20130106;
Query OK, 0 rows affected (27.18 sec)

MySQL TRUNCATE TABLE command Usage Summary