Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql delete if not in another table

DELETE FROM BLOB
 WHERE fileid NOT IN (SELECT f.id 
                        FROM FILES f)
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #mysql #delete #table
ADD COMMENT
Topic
Name
3+8 =