MariaDB 10.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table table_A (col1 int, col2 int);
insert into table_A values(10, 10), (15, 15), (35, 35), (45, 45);

create table table_B (col1 int, col2 int);
insert into table_B values (10, 10), (2000, 2000), (35, 35), (6000, 6000);

Records: 4  Duplicates: 0  Warnings: 0



Records: 4  Duplicates: 0  Warnings: 0


SELECT * FROM table_A;
SELECT * FROM table_B;


col1
col2


10
10

15
15

35
35

45
45




col1
col2


10
10

2000
2000

35
35

6000
6000


SELECT * FROM table_B EXCEPT ALL SELECT * FROM table_A;


col1
col2


2000
2000

6000
6000


INSERT INTO table_A
SELECT * FROM table_B EXCEPT ALL SELECT * FROM table_A;

Records: 2  Duplicates: 0  Warnings: 0


SELECT * FROM table_A;
SELECT * FROM table_B;


col1
col2


10
10

15
15

35
35

45
45

2000
2000

6000
6000




col1
col2


10
10

2000
2000

35
35

6000
6000


create table table_C (col1 int, col2 int, col3 int, col4 int, col5 int);
insert into table_C values
  (10, 10, 10, 10, 10),
  (15, 15, 15, 15, 15),
  (35, 35, 35, 35, 35),
  (45, 45, 45, 45, 45);

create table table_D (col1 int, col2 int, col3 int, col4 int, col5 int);
insert into table_D values
  (10, 10, 11, 10, 10), -- note third value is different
  (2000, 2000, 2000, 2000, 2000),
  (35, 35, 35, 35, 35),
  (6000, 6000, 6000, 6000, 6000);

Records: 4  Duplicates: 0  Warnings: 0



Records: 4  Duplicates: 0  Warnings: 0


SELECT * FROM table_C;
SELECT * FROM table_D;


col1
col2
col3
col4
col5


10
10
10
10
10

15
15
15
15
15

35
35
35
35
35

45
45
45
45
45




col1
col2
col3
col4
col5


10
10
11
10
10

2000
2000
2000
2000
2000

35
35
35
35
35

6000
6000
6000
6000
6000


SELECT * FROM table_D EXCEPT ALL SELECT * FROM table_C;


col1
col2
col3
col4
col5


10
10
11
10
10

2000
2000
2000
2000
2000

6000
6000
6000
6000
6000


INSERT INTO table_C
SELECT * FROM table_D EXCEPT ALL SELECT * FROM table_C;

Records: 3  Duplicates: 0  Warnings: 0


SELECT * FROM table_C;
SELECT * FROM table_D;


col1
col2
col3
col4
col5


10
10
10
10
10

15
15
15
15
15

35
35
35
35
35

45
45
45
45
45

10
10
11
10
10

2000
2000
2000
2000
2000

6000
6000
6000
6000
6000




col1
col2
col3
col4
col5


10
10
11
10
10

2000
2000
2000
2000
2000

35
35
35
35
35

6000
6000
6000
6000
6000
col1	col2	col3	col4	col5
10	10	11	10	10
2000	2000	2000	2000	2000
35	35	35	35	35
6000	6000	6000	6000	6000