/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

16 votes193 views2 answers
Add column if not exists mysql
SQL
49 votes267 views6 answers
Get duplicate records in sql
SQL
5 votes236 views4 answers
Mysql on duplicate key update
SQL
0 vote150 views1 answer
Sql select rows with simlar names
SQL
1 vote197 views1 answer
How to truncate a table in databse
SQL
6 votes180 views2 answers
Mysql set primary key
SQL
2 votes198 views1 answer
How to find table table in stored procedure sql server
SQL
5 votes178 views1 answer
JBDC
SQL
1 vote164 views1 answer
Sql server 2016 reseed identity
SQL
2 votes197 views1 answer
Mysql time ago difference
SQL

Share