Organizational Research By

Surprising Reserch Topic

What is the difference between truncate and delete?



asked Sep 13, 2013 in MYSQL by rajesh
edited Sep 12, 2013
0 votes
64 views



Related Hot Questions

1 Answer

0 votes
Delete command is used to delete data from a table for example Remove emails where we write a script to delete the customer’s data. It deletes the rows of data from a table. The syntax of it as follows:
DELETE FROM table_name
Whereas, truncate is very dangerous command and should be used carefully as it deletes every row from a table. The syntax of it as follows:
TRUNCATE TABLE "table_name"
 
answered Sep 13, 2013 by rajesh
edited Sep 12, 2013

...