please explain truncate | Sololearn: Learn to code for FREE!
Nouvelle formation ! Tous les codeurs devraient apprendre l'IA générative !
Essayez une leçon gratuite
+ 1

please explain truncate

28th Feb 2016, 1:46 PM
Mithun Miths
Mithun Miths - avatar
3 Réponses
+ 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