Which can be used to delete all the rows if a table 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: delete all records from table
DELETE FROM table_name;