MySQL 8.0

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

select version();


version()


8.0.21


CREATE TABLE link_1
(
  id_1 INTEGER PRIMARY KEY,
  dat_1 VARCHAR (20) NOT NULL
)
CREATE TABLE link_2
(
  id_2 INTEGER PRIMARY KEY,
  dat_2 VARCHAR (20) NOT NULL
)
INSERT INTO link_1 VALUES (1, 'sdfs'), (2, 'czcv'), (3, 'ityt');
INSERT INTO link_2 VALUES (6, 'bbmbm'), (7, 'ljlj'), (8, 't5555');
CREATE TABLE assoc 
(
  l_id_1 INTEGER NOT NULL,
  l_id_2 INTEGER NOT NULL,
  CONSTRAINT accoc_l_1_fk FOREIGN KEY (l_id_1) REFERENCES link_1 (id_1)
    ON DELETE CASCADE,
  CONSTRAINT accoc_l_2_fk FOREIGN KEY (l_id_2) REFERENCES link_2 (id_2)
    ON DELETE CASCADE
);
INSERT INTO assoc VALUES (1, 6), (1, 7), (1, 8), (2, 7), (2, 8), (3, 6), (3, 8);
SELECT * FROM assoc;


l_id_1
l_id_2


1
6

1
7

1
8

2
7

2
8

3
6

3
8


DELETE FROM link_1 WHERE id_1 = 1;
SELECT * FROM assoc;


l_id_1
l_id_2


2
7

2
8

3
6

3
8