DELETE ROW WITH CONDITION IN MYSQL code example

Example 1: mysql delete entire row on condition

DELETE FROM my_table WHERE col1 > 2;
DELETE FROM my_table WHERE col1 IS NOT NULL;

Example 2: mysql delete entire row on condition

DELETE FROM table_name [WHERE Clause]