Monthly Archives: May 2015

What is Difference between MySQL delete and truncate table

This very common question in interviews.  Both remove records from the table, so what is the difference. Delete :                      Syntax :  Delete from TableName [where condition]; Deletes record  from table

Posted in Mysql