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.