Difference b/w TRUNCATE, DELETE and DROP command in MySQL
DELETE command is used to delete data from a table based on where condition. in case of using a DELETE command we can undo this operation.
TRUNCATE command permanently delete all rows from a table the operation can't undo. it simply means empty a table and re-create blank table structure without
any data in it.
DROP command is used to delete a table with its structure from the database permanently and the operation can't be undo.