programming faqs interview questions tech technical educational freshers guide preparation interviews hr telephonic
try another color:
try another fontsize: 60% 70% 80% 90%
Programming FAQs

Difference between Drop, Truncate and Delete statements in MySQL

Average: 3.2 (20 votes)

Drop - deletes the data as

Drop - deletes the data as well as structure
Truncate - deletes only the data, and resets the auto increment column to 0
Delete - Deletes the selected/all rows from a table, it doest not reset auto increment., here we can delete set of records by specifying the condition in where clause

If Delete is used, the date

If Delete is used, the date can be rollback or commit depending on the requirements.