/SQL/Mysql delete if not in another table

Mysql delete if not in another table

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

0

Source: stackoverflow.com

Mysql delete if not in another table

DELETE FROM BLOB
 WHERE fileid NOT IN (SELECT f.id 
                        FROM FILES f)

0

Source: stackoverflow.com

Mysql delete if not in another table

DELETE FROM BLOB 
 WHERE NOT EXISTS(SELECT NULL
                    FROM FILES f
                   WHERE f.id = fileid)

0

Source: stackoverflow.com

Similar codes

4 votes129 views2 answers
Mysql show indexes on table
SQL
31 votes120 views1 answer
Postgresql add column with constraint
SQL
0 vote136 views1 answer
Oracle sql number to varchar2
SQL
0 vote118 views1 answer
Acutal month year
SQL
0 vote128 views1 answer
Pl/ sql change currency
SQL
0 vote128 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote118 views1 answer
What is the essence of SQL?
SQL
0 vote132 views3 answers
Sql parenthetical expression examples
SQL
2 votes116 views2 answers
Change varchar length mysql
SQL
-1 vote134 views1 answer
How to reset autoincrement in sqlite java
SQL

Share