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 ...
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 ...