There can be many reasons to delete all records in a MySQL Database table and there are two ways you can acheive this using the “truncate” command or by using the “delete” command. While the ultimate net result is the same, there are differences you should know.
Key differences are
1. “truncate” uses DDL and is fast while “delete” doesn’t and hence slower (depending on the number of records).
2. “truncate” resets the auto increment counter while “delete” doesn’t.