Recognition

No awards yet.

Posts

1 Posts
  • Published Question

    Gregory Broccoli - difference between TRUNCATE and DELETE

    Hi, I am Gregory Broccoli I want to know, What is the difference between TRUNCATE and DELETE in MySQL. Thanks, Gregory Broccoli
    Accepted Answer: DELETE DELETE is a DML Command. DELETE statement is executed using a row lock, each row in the table is locked for deletion. We can specify filters in where clause It deletes specified data if where condition exists....
    1 By gregorybroccoli MySQL