Hi, I am Gregory Broccoli
I want to know, What is the difference between TRUNCATE and DELETE in MySQL.
Thanks, Gregory Broccoli
DELETE is a DML Command.
DELETE statement is executed using a row lock, each row in the table is locked for deletion.
We can specify filters in where clause
It deletes specified data if where condition exists....