clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2249115 fiddles created (32114 in the last week).

CREATE TABLE table1 SELECT 1 x, 1 y UNION SELECT 2,2 UNION SELECT 3,3 UNION SELECT 5, null UNION SELECT null, 6; CREATE TABLE table2 SELECT 1 x, 1 y UNION SELECT 2,2 UNION SELECT 3,4 UNION SELECT 5, null UNION SELECT 6, null;
 hidden batch(es)


SELECT * FROM table1; SELECT * FROM table2;
x y
1 1
2 2
3 3
5
6
x y
1 1
2 2
3 4
5
6
 hidden batch(es)


DELETE t1.*, t2.* FROM table1 t1 JOIN table2 t2 ON t1.x <=> t2.x AND t1.y <=> t2.y;
 hidden batch(es)


SELECT * FROM table1; SELECT * FROM table2;
x y
3 3
6
x y
3 4
6
 hidden batch(es)