Question: what is the difference between delete table and truncate table commands in mysql?
Answer: TRUNCATE removes all rows from a table. The operation cannot be rolled back and no triggers will be fired. ... DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. Therefore DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.