Question · SQL and MySQL course · Module 5: Modifying data (DML)
Difference between DELETE and TRUNCATE
How does TRUNCATE differ from DELETE without WHERE?
Answer options
- TRUNCATE allows a WHERE clause, while DELETE does not
- TRUNCATE is faster on large tables and resets the AUTO_INCREMENT counter
- TRUNCATE removes only one row, while DELETE removes all
- There is no difference - they are two words for the same thing
You can check the correct answer by solving this task in the CodeWorlds game.