mysql delete rows condition code example

Example 1: mysql delete row

DELETE FROM products WHERE product_id=1;

Example 2: mysql delete entire row on condition

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

Example 3: mysql delete entire row on condition

DELETE FROM table_name [WHERE Clause]

Example 4: mysql delete if not in another table

DELETE b FROM BLOB b 
  LEFT JOIN FILES f ON f.id = b.fileid 
      WHERE f.id IS NULL

Tags:

Shell Example

Related