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 vote145 views1 answer
Migration graphql
SQL
2 votes161 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote150 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
2 votes126 views2 answers
How to get capital letter first in sql
SQL
0 vote133 views1 answer
Postgres call view
SQL
15 votes124 views4 answers
T-sql drop function if exists
SQL
0 vote142 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote212 views1 answer
Alter table name including schema
SQL
51 votes370 views6 answers
Installing mysql on ubuntu
SQL
0 vote171 views1 answer
Varchar2 length in oracle
SQL