Use of drop, truncate, and delete----Delete table data in MySQL statement

Degree from strong to weak 1, drop table TB drop directly delete the form, no way back 2, truncate (table) TB Delete all data in the table, cannot be used with where 3, delete from TB (where) Delete data in a table (can make a row) difference: Truncate and delete difference 1, transaction: Truncate is not rollback, but delete can rollback; Reason: truncate Delete whole table data (DDL statement, Implicit commit), delete is a row of deletes, can rollback 2, effect: Truncate will re-level and index (ID zero), delete will not delete index 3, Trunca         TE cannot trigger any delete triggers. 4, delete Delete can return the number of rows

Use of drop, truncate, and delete----Delete table data in MySQL statement