how to delete all rows from a table in sql 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: delet all record statment sql

DELETE FROM category where category_model is  'NULL';