Google News
logo
MySQL - Interview Questions
What is the difference between TRUNCATE and DELETE in MySQL?
* TRUNCATE is a DDL command, and DELETE is a DML command.

* It is not possible to use Where command with TRUNCATE QLbut you can use it with DELETE command.

* TRUNCATE cannot be used with indexed views, whereas DELETE can be used with indexed views.

* The DELETE command is used to delete data from a table. It only deletes the rows of data from the table while truncate is a very dangerous command and should be used carefully because it deletes every row permanently from a table.
Advertisement