DELETE * removes all rows in a table while TRUNCATE removes all rows and resets auto-increment values.

• DELETE * is a DML command and TRUNCATE is a DDL command

• DELETE * is slower as it logs individual ro...read more