Originally Posted by bvani 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....................
Forum Rules