/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

0 vote338 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote338 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote320 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote318 views1 answer
Mysql insert into select with recursive
SQL
-1 vote316 views2 answers
On update cascade
SQL
8 votes341 views1 answer
How to check mysql version in xampp
SQL
1 vote340 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote327 views3 answers
Get all tables postgres
SQL
0 vote348 views1 answer
Modifier une valeur sql
SQL
16 votes402 views3 answers
Get count of duplicate records
SQL

Share