MySQL 8.0

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

select @@version;


@@version


8.0.27


CREATE TABLE folders ( folder_id int primary key );
CREATE TABLE xrows   (
    row_id    int primary key
  , folder_id int
  , FOREIGN KEY (folder_id) REFERENCES folders (folder_id) ON DELETE CASCADE
);
INSERT INTO folders VALUES (1), (2), (3);
INSERT INTO xrows VALUES
    (1, 1)
  , (2, 1)
  , (3, 1)
  , (4, 2)
  , (5, 3)
  , (6, 2)
;
SELECT * FROM xrows;


row_id
folder_id


1
1

2
1

3
1

4
2

6
2

5
3


DELETE FROM folders WHERE folder_id = 1;
SELECT * FROM xrows;


row_id
folder_id


4
2

6
2

5
3