+ 1

please explain truncate

28th Feb 2016, 1:46 PM
Mithun Miths
Mithun Miths - avatar
3 Answers
+ 2
Truncate is used to remove all the data from the table if you have to keep your structure of the table.
18th Jul 2016, 9:27 PM
Suryaprakash Tiwari
Suryaprakash Tiwari - avatar
+ 1
let table be a bowl and data be water in it ,when we truncate we actually throw the water away for bowl to be used again
14th Jul 2016, 8:09 PM
manish rawat
manish rawat - avatar
0
Truncate will delete everything in the table and reset the auto increment value.
23rd Mar 2016, 1:51 PM
S. M. Rajibul Huda
S. M. Rajibul Huda - avatar