MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

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;
SELECT * FROM table1;
SELECT * FROM table2;


x
y


1
1

2
2

3
3

5
null

null
6




x
y


1
1

2
2

3
4

5
null

6
null


DELETE t1.*, t2.*
FROM table1 t1
JOIN table2 t2 ON t1.x <=> t2.x
              AND t1.y <=> t2.y;
SELECT * FROM table1;
SELECT * FROM table2;


x
y


3
3

null
6




x
y


3
4

6
null

x	y
1	1
2	2
3	3
5	null
null	6

x	y
1	1
2	2
3	4
5	null
6	null

x	y
3	3
null	6

x	y
3	4
6	null