Mysql find missing values

-- Find missing t1 values in t2 (based on 'id' field)
SELECT * FROM t1 WHERE t1.id NOT IN (SELECT id FROM t2);
-- or
SELECT * FROM t1 WHERE NOT exists (
    SELECT NULL FROM t2 WHERE t2.id = t1.id
);
-- or
SELECT t1.* FROM t1 LEFT OUTER JOIN t2 ON t2.id = t1.id WHERE t2.id IS NULL;

Similar codes

3 votes132 views2 answers
Sql server current date without time
SQL
0 vote128 views1 answer
Get who is hired in specific month in sql
SQL
0 vote135 views1 answer
Mysql query with sql to get the next row
SQL
0 vote136 views2 answers
How to save result of sqlite query in a table
SQL
0 vote158 views1 answer
Replace sqlalchemy
SQL
0 vote129 views1 answer
Events not working db
SQL
1 vote156 views2 answers
Mysql does sentance contain word
SQL
0 vote143 views1 answer
Into operator in sql
SQL
8 votes131 views2 answers
Between operator
SQL
0 vote131 views1 answer
Postegresql update to null
SQL