drop remove table with all data mysql code example

Example 1: delete all rows from table mysql

-- Quick, no possible rollback
TRUNCATE TABLE my_table;
-- With rollback
DELETE FROM my_table;
COMMIT;

Example 2: how to delete a table entry in mysql

DELETE FROM `table_name` [WHERE condition];