Quote Originally Posted by bvani View Post
Hi

can any one tell me the difference between delete and truncate statement in mysql . which is better to use?
with delete operation one can rollback the data; this shows after performing delete operation , data is not completely deleted;

but in case of trancate , one cannot retrive the data using rollback operation....................