if-not-exists is a common SQL condition used to check if an entity exists.

learn more… | top users | synonyms

1
vote
1answer
318 views

MySQL: NOT EXISTS vs LEFT OUTER JOIN…IS NULL

Is NOT EXISTS or LEFT OUTER JOIN...IS NULL more efficient for finding records in one table that aren't in another? Specifically, I'm trying to figure out which of the two queries below is better: ...