Answer the question
In order to leave comments, you need to log in
How to check for missing records in MySQL?
Hello.
There is a list of values. Of these, some are present in the table and some are not. How can I find out which values are missing in the table?
Answer the question
In order to leave comments, you need to log in
SELECT * FROM t1 WHERE NOT EXISTS (SELECT * FROM t2 where t1.id = t2.id);
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question