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

0 vote126 views2 answers
Mysql slave status
SQL
0 vote148 views1 answer
Tinydb add table
SQL
0 vote139 views1 answer
Sql select most frequent value in column
SQL
0 vote141 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote158 views3 answers
Convert sql query to python pandas
SQL
2 votes142 views1 answer
Mysql application.properties spring boot
SQL
0 vote152 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote145 views1 answer
Insert into select with group by
SQL
0 vote146 views1 answer
Select year from dual oracle
SQL
4 votes166 views5 answers
Get last query in codeigniter 4
SQL