top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is difference between TRUNCATE and DELETE in MySQL?

0 votes
442 views
What is difference between TRUNCATE and DELETE in MySQL?
posted Jun 5, 2014 by Amanpreet Kaur

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

1: DELETE is a DML(data manipulation language) command whereas truncate is a DDL(data definition language) command.

2 : Truncate is much faster than Delete.

3 : We can not roll back in truncate but in delete we can rollback.

4 : We can not use where clause in truncate but in delete ,we can use conditions using where clause.

answer Jun 6, 2014 by Karamjeet Singh
...