This article explains the use and difference of DELETE, TRUNCATE and DROP statements of MySQL. 1. DELETE : DELETE command is used to delete all or specific records from MySQL table. The records delete ...

DELETE comes under DML(Data Manipulation Language). DELETE can be used to delete a particular row by using WHERE clause. It is slower than TRUNCATE as it keeps logs. Rollback is possible when used ...