In mysql, delete and truncate both are used for deleting data from table.deletedelete comes under dml (datamanipulation language). delete canbe used to delete a particular rowby using where clause.it ...

However, the SQL TRUNCATE statement cannot be used with a WHERE clause and it cannot be rolled back. Third, it can affect the performance and integrity of your database if you do not use it properly.

"In MySQL 5.5 and higher, TRUNCATE TABLE is not allowed for InnoDB tables referenced by foreign keys. For ease of upgrading, rewrite such statements to use DELETE instead." ...