MySQL Database - Truncate , Drop, Delete difference

There is database statements truncate, delete and drop. These used to delete record/records and table. We have to use these based on the need.

Truncate: To delete the records in the table. It resets the auto increment field - it delete the entry in auto increment sequence table. It gives you brand new table structure without records

Delete: Delete the records based on condition. If you want to delete specific records based on condition then choose this.

Drop : It removes table structure and records.