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

4 votes115 views1 answer
Delete record mysql query
SQL
0 vote131 views1 answer
Query params sql insert python f string
SQL
1 vote123 views1 answer
Change table to innodb mysql
SQL
0 vote117 views1 answer
List mysql tables and views
SQL
0 vote112 views1 answer
Mysql disable query caching
SQL
0 vote116 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
0 vote125 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote114 views1 answer
Mysql to get column name in database
SQL
0 vote125 views1 answer
Hex string sql becomes int64
SQL
0 vote118 views1 answer
Excute raw query
SQL