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

Remarks TRUNCATE is equivalent to a DELETE statement without a WHERE clause, except that each individual row deletion is not entered into the transaction log. After a TRUNCATE TABLE statement, the ...

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