MySQL 8.0

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

CREATE TABLE actor (
    actor_id int auto_increment not null primary key,
    first_name char(45) NOT NULL,
    last_name char(45) NOT NULL,
    last_update timestamp DEFAULT now() NOT NULL
);





CREATE TABLE film (
    film_id int auto_increment not null primary key,
    title char(45) NOT NULL,
    last_update timestamp DEFAULT now() NOT NULL
);
CREATE TABLE film_actor (
    actor_id int NOT NULL,
    film_id int NOT NULL,
    last_update timestamp DEFAULT now() NOT NULL,
    
    primary key(actor_id, film_id)
);
CREATE INDEX idx_film_actor_a_f ON film_actor(actor_id, film_id)
SET SESSION cte_max_recursion_depth = 1000000;
insert into film(title)
with recursive series(n) as
(
    select 1
    union all
    select n + 1 from series where n < 100
)
select substring(md5(rand()) from 1 for 30) from series;
insert into actor(first_name, last_name)
with recursive series(n) as
(
    select 1
    union all
    select n + 1 from series where n < 500
)
select substring(md5(rand()) from 1 for 30), substring(md5(rand()) from 1 for 30) from series;
insert into film_actor(film_id, actor_id) select film_id, actor_id from film, (select actor_id from actor order by rand() limit 2) actor;
select * from film_actor;


actor_id
film_id
last_update


217
1
2022-08-09 17:54:57

217
2
2022-08-09 17:54:57

217
3
2022-08-09 17:54:57

217
4
2022-08-09 17:54:57

217
5
2022-08-09 17:54:57

217
6
2022-08-09 17:54:57

217
7
2022-08-09 17:54:57

217
8
2022-08-09 17:54:57

217
9
2022-08-09 17:54:57

217
10
2022-08-09 17:54:57

217
11
2022-08-09 17:54:57

217
12
2022-08-09 17:54:57

217
13
2022-08-09 17:54:57

217
14
2022-08-09 17:54:57

217
15
2022-08-09 17:54:57

217
16
2022-08-09 17:54:57

217
17
2022-08-09 17:54:57

217
18
2022-08-09 17:54:57

217
19
2022-08-09 17:54:57

217
20
2022-08-09 17:54:57

217
21
2022-08-09 17:54:57

217
22
2022-08-09 17:54:57

217
23
2022-08-09 17:54:57

217
24
2022-08-09 17:54:57

217
25
2022-08-09 17:54:57

217
26
2022-08-09 17:54:57

217
27
2022-08-09 17:54:57

217
28
2022-08-09 17:54:57

217
29
2022-08-09 17:54:57

217
30
2022-08-09 17:54:57

217
31
2022-08-09 17:54:57

217
32
2022-08-09 17:54:57

217
33
2022-08-09 17:54:57

217
34
2022-08-09 17:54:57

217
35
2022-08-09 17:54:57

217
36
2022-08-09 17:54:57

217
37
2022-08-09 17:54:57

217
38
2022-08-09 17:54:57

217
39
2022-08-09 17:54:57

217
40
2022-08-09 17:54:57

217
41
2022-08-09 17:54:57

217
42
2022-08-09 17:54:57

217
43
2022-08-09 17:54:57

217
44
2022-08-09 17:54:57

217
45
2022-08-09 17:54:57

217
46
2022-08-09 17:54:57

217
47
2022-08-09 17:54:57

217
48
2022-08-09 17:54:57

217
49
2022-08-09 17:54:57

217
50
2022-08-09 17:54:57

217
51
2022-08-09 17:54:57

217
52
2022-08-09 17:54:57

217
53
2022-08-09 17:54:57

217
54
2022-08-09 17:54:57

217
55
2022-08-09 17:54:57

217
56
2022-08-09 17:54:57

217
57
2022-08-09 17:54:57

217
58
2022-08-09 17:54:57

217
59
2022-08-09 17:54:57

217
60
2022-08-09 17:54:57

217
61
2022-08-09 17:54:57

217
62
2022-08-09 17:54:57

217
63
2022-08-09 17:54:57

217
64
2022-08-09 17:54:57

217
65
2022-08-09 17:54:57

217
66
2022-08-09 17:54:57

217
67
2022-08-09 17:54:57

217
68
2022-08-09 17:54:57

217
69
2022-08-09 17:54:57

217
70
2022-08-09 17:54:57

217
71
2022-08-09 17:54:57

217
72
2022-08-09 17:54:57

217
73
2022-08-09 17:54:57

217
74
2022-08-09 17:54:57

217
75
2022-08-09 17:54:57

217
76
2022-08-09 17:54:57

217
77
2022-08-09 17:54:57

217
78
2022-08-09 17:54:57

217
79
2022-08-09 17:54:57

217
80
2022-08-09 17:54:57

217
81
2022-08-09 17:54:57

217
82
2022-08-09 17:54:57

217
83
2022-08-09 17:54:57

217
84
2022-08-09 17:54:57

217
85
2022-08-09 17:54:57

217
86
2022-08-09 17:54:57

217
87
2022-08-09 17:54:57

217
88
2022-08-09 17:54:57

217
89
2022-08-09 17:54:57

217
90
2022-08-09 17:54:57

217
91
2022-08-09 17:54:57

217
92
2022-08-09 17:54:57

217
93
2022-08-09 17:54:57

217
94
2022-08-09 17:54:57

217
95
2022-08-09 17:54:57

217
96
2022-08-09 17:54:57

217
97
2022-08-09 17:54:57

217
98
2022-08-09 17:54:57

217
99
2022-08-09 17:54:57

217
100
2022-08-09 17:54:57

415
1
2022-08-09 17:54:57

415
2
2022-08-09 17:54:57

415
3
2022-08-09 17:54:57

415
4
2022-08-09 17:54:57

415
5
2022-08-09 17:54:57

415
6
2022-08-09 17:54:57

415
7
2022-08-09 17:54:57

415
8
2022-08-09 17:54:57

415
9
2022-08-09 17:54:57

415
10
2022-08-09 17:54:57

415
11
2022-08-09 17:54:57

415
12
2022-08-09 17:54:57

415
13
2022-08-09 17:54:57

415
14
2022-08-09 17:54:57

415
15
2022-08-09 17:54:57

415
16
2022-08-09 17:54:57

415
17
2022-08-09 17:54:57

415
18
2022-08-09 17:54:57

415
19
2022-08-09 17:54:57

415
20
2022-08-09 17:54:57

415
21
2022-08-09 17:54:57

415
22
2022-08-09 17:54:57

415
23
2022-08-09 17:54:57

415
24
2022-08-09 17:54:57

415
25
2022-08-09 17:54:57

415
26
2022-08-09 17:54:57

415
27
2022-08-09 17:54:57

415
28
2022-08-09 17:54:57

415
29
2022-08-09 17:54:57

415
30
2022-08-09 17:54:57

415
31
2022-08-09 17:54:57

415
32
2022-08-09 17:54:57

415
33
2022-08-09 17:54:57

415
34
2022-08-09 17:54:57

415
35
2022-08-09 17:54:57

415
36
2022-08-09 17:54:57

415
37
2022-08-09 17:54:57

415
38
2022-08-09 17:54:57

415
39
2022-08-09 17:54:57

415
40
2022-08-09 17:54:57

415
41
2022-08-09 17:54:57

415
42
2022-08-09 17:54:57

415
43
2022-08-09 17:54:57

415
44
2022-08-09 17:54:57

415
45
2022-08-09 17:54:57

415
46
2022-08-09 17:54:57

415
47
2022-08-09 17:54:57

415
48
2022-08-09 17:54:57

415
49
2022-08-09 17:54:57

415
50
2022-08-09 17:54:57

415
51
2022-08-09 17:54:57

415
52
2022-08-09 17:54:57

415
53
2022-08-09 17:54:57

415
54
2022-08-09 17:54:57

415
55
2022-08-09 17:54:57

415
56
2022-08-09 17:54:57

415
57
2022-08-09 17:54:57

415
58
2022-08-09 17:54:57

415
59
2022-08-09 17:54:57

415
60
2022-08-09 17:54:57

415
61
2022-08-09 17:54:57

415
62
2022-08-09 17:54:57

415
63
2022-08-09 17:54:57

415
64
2022-08-09 17:54:57

415
65
2022-08-09 17:54:57

415
66
2022-08-09 17:54:57

415
67
2022-08-09 17:54:57

415
68
2022-08-09 17:54:57

415
69
2022-08-09 17:54:57

415
70
2022-08-09 17:54:57

415
71
2022-08-09 17:54:57

415
72
2022-08-09 17:54:57

415
73
2022-08-09 17:54:57

415
74
2022-08-09 17:54:57

415
75
2022-08-09 17:54:57

415
76
2022-08-09 17:54:57

415
77
2022-08-09 17:54:57

415
78
2022-08-09 17:54:57

415
79
2022-08-09 17:54:57

415
80
2022-08-09 17:54:57

415
81
2022-08-09 17:54:57

415
82
2022-08-09 17:54:57

415
83
2022-08-09 17:54:57

415
84
2022-08-09 17:54:57

415
85
2022-08-09 17:54:57

415
86
2022-08-09 17:54:57

415
87
2022-08-09 17:54:57

415
88
2022-08-09 17:54:57

415
89
2022-08-09 17:54:57

415
90
2022-08-09 17:54:57

415
91
2022-08-09 17:54:57

415
92
2022-08-09 17:54:57

415
93
2022-08-09 17:54:57

415
94
2022-08-09 17:54:57

415
95
2022-08-09 17:54:57

415
96
2022-08-09 17:54:57

415
97
2022-08-09 17:54:57

415
98
2022-08-09 17:54:57

415
99
2022-08-09 17:54:57

415
100
2022-08-09 17:54:57

actor_id	film_id	last_update
217	1	2022-08-09 17:54:57
217	2	2022-08-09 17:54:57
217	3	2022-08-09 17:54:57
217	4	2022-08-09 17:54:57
217	5	2022-08-09 17:54:57
217	6	2022-08-09 17:54:57
217	7	2022-08-09 17:54:57
217	8	2022-08-09 17:54:57
217	9	2022-08-09 17:54:57
217	10	2022-08-09 17:54:57
217	11	2022-08-09 17:54:57
217	12	2022-08-09 17:54:57
217	13	2022-08-09 17:54:57
217	14	2022-08-09 17:54:57
217	15	2022-08-09 17:54:57
217	16	2022-08-09 17:54:57
217	17	2022-08-09 17:54:57
217	18	2022-08-09 17:54:57
217	19	2022-08-09 17:54:57
217	20	2022-08-09 17:54:57
217	21	2022-08-09 17:54:57
217	22	2022-08-09 17:54:57
217	23	2022-08-09 17:54:57
217	24	2022-08-09 17:54:57
217	25	2022-08-09 17:54:57
217	26	2022-08-09 17:54:57
217	27	2022-08-09 17:54:57
217	28	2022-08-09 17:54:57
217	29	2022-08-09 17:54:57
217	30	2022-08-09 17:54:57
217	31	2022-08-09 17:54:57
217	32	2022-08-09 17:54:57
217	33	2022-08-09 17:54:57
217	34	2022-08-09 17:54:57
217	35	2022-08-09 17:54:57
217	36	2022-08-09 17:54:57
217	37	2022-08-09 17:54:57
217	38	2022-08-09 17:54:57
217	39	2022-08-09 17:54:57
217	40	2022-08-09 17:54:57
217	41	2022-08-09 17:54:57
217	42	2022-08-09 17:54:57
217	43	2022-08-09 17:54:57
217	44	2022-08-09 17:54:57
217	45	2022-08-09 17:54:57
217	46	2022-08-09 17:54:57
217	47	2022-08-09 17:54:57
217	48	2022-08-09 17:54:57
217	49	2022-08-09 17:54:57
217	50	2022-08-09 17:54:57
217	51	2022-08-09 17:54:57
217	52	2022-08-09 17:54:57
217	53	2022-08-09 17:54:57
217	54	2022-08-09 17:54:57
217	55	2022-08-09 17:54:57
217	56	2022-08-09 17:54:57
217	57	2022-08-09 17:54:57
217	58	2022-08-09 17:54:57
217	59	2022-08-09 17:54:57
217	60	2022-08-09 17:54:57
217	61	2022-08-09 17:54:57
217	62	2022-08-09 17:54:57
217	63	2022-08-09 17:54:57
217	64	2022-08-09 17:54:57
217	65	2022-08-09 17:54:57
217	66	2022-08-09 17:54:57
217	67	2022-08-09 17:54:57
217	68	2022-08-09 17:54:57
217	69	2022-08-09 17:54:57
217	70	2022-08-09 17:54:57
217	71	2022-08-09 17:54:57
217	72	2022-08-09 17:54:57
217	73	2022-08-09 17:54:57
217	74	2022-08-09 17:54:57
217	75	2022-08-09 17:54:57
217	76	2022-08-09 17:54:57
217	77	2022-08-09 17:54:57
217	78	2022-08-09 17:54:57
217	79	2022-08-09 17:54:57
217	80	2022-08-09 17:54:57
217	81	2022-08-09 17:54:57
217	82	2022-08-09 17:54:57
217	83	2022-08-09 17:54:57
217	84	2022-08-09 17:54:57
217	85	2022-08-09 17:54:57
217	86	2022-08-09 17:54:57
217	87	2022-08-09 17:54:57
217	88	2022-08-09 17:54:57
217	89	2022-08-09 17:54:57
217	90	2022-08-09 17:54:57
217	91	2022-08-09 17:54:57
217	92	2022-08-09 17:54:57
217	93	2022-08-09 17:54:57
217	94	2022-08-09 17:54:57
217	95	2022-08-09 17:54:57
217	96	2022-08-09 17:54:57
217	97	2022-08-09 17:54:57
217	98	2022-08-09 17:54:57
217	99	2022-08-09 17:54:57
217	100	2022-08-09 17:54:57
415	1	2022-08-09 17:54:57
415	2	2022-08-09 17:54:57
415	3	2022-08-09 17:54:57
415	4	2022-08-09 17:54:57
415	5	2022-08-09 17:54:57
415	6	2022-08-09 17:54:57
415	7	2022-08-09 17:54:57
415	8	2022-08-09 17:54:57
415	9	2022-08-09 17:54:57
415	10	2022-08-09 17:54:57
415	11	2022-08-09 17:54:57
415	12	2022-08-09 17:54:57
415	13	2022-08-09 17:54:57
415	14	2022-08-09 17:54:57
415	15	2022-08-09 17:54:57
415	16	2022-08-09 17:54:57
415	17	2022-08-09 17:54:57
415	18	2022-08-09 17:54:57
415	19	2022-08-09 17:54:57
415	20	2022-08-09 17:54:57
415	21	2022-08-09 17:54:57
415	22	2022-08-09 17:54:57
415	23	2022-08-09 17:54:57
415	24	2022-08-09 17:54:57
415	25	2022-08-09 17:54:57
415	26	2022-08-09 17:54:57
415	27	2022-08-09 17:54:57
415	28	2022-08-09 17:54:57
415	29	2022-08-09 17:54:57
415	30	2022-08-09 17:54:57
415	31	2022-08-09 17:54:57
415	32	2022-08-09 17:54:57
415	33	2022-08-09 17:54:57
415	34	2022-08-09 17:54:57
415	35	2022-08-09 17:54:57
415	36	2022-08-09 17:54:57
415	37	2022-08-09 17:54:57
415	38	2022-08-09 17:54:57
415	39	2022-08-09 17:54:57
415	40	2022-08-09 17:54:57
415	41	2022-08-09 17:54:57
415	42	2022-08-09 17:54:57
415	43	2022-08-09 17:54:57
415	44	2022-08-09 17:54:57
415	45	2022-08-09 17:54:57
415	46	2022-08-09 17:54:57
415	47	2022-08-09 17:54:57
415	48	2022-08-09 17:54:57
415	49	2022-08-09 17:54:57
415	50	2022-08-09 17:54:57
415	51	2022-08-09 17:54:57
415	52	2022-08-09 17:54:57
415	53	2022-08-09 17:54:57
415	54	2022-08-09 17:54:57
415	55	2022-08-09 17:54:57
415	56	2022-08-09 17:54:57
415	57	2022-08-09 17:54:57
415	58	2022-08-09 17:54:57
415	59	2022-08-09 17:54:57
415	60	2022-08-09 17:54:57
415	61	2022-08-09 17:54:57
415	62	2022-08-09 17:54:57
415	63	2022-08-09 17:54:57
415	64	2022-08-09 17:54:57
415	65	2022-08-09 17:54:57
415	66	2022-08-09 17:54:57
415	67	2022-08-09 17:54:57
415	68	2022-08-09 17:54:57
415	69	2022-08-09 17:54:57
415	70	2022-08-09 17:54:57
415	71	2022-08-09 17:54:57
415	72	2022-08-09 17:54:57
415	73	2022-08-09 17:54:57
415	74	2022-08-09 17:54:57
415	75	2022-08-09 17:54:57
415	76	2022-08-09 17:54:57
415	77	2022-08-09 17:54:57
415	78	2022-08-09 17:54:57
415	79	2022-08-09 17:54:57
415	80	2022-08-09 17:54:57
415	81	2022-08-09 17:54:57
415	82	2022-08-09 17:54:57
415	83	2022-08-09 17:54:57
415	84	2022-08-09 17:54:57
415	85	2022-08-09 17:54:57
415	86	2022-08-09 17:54:57
415	87	2022-08-09 17:54:57
415	88	2022-08-09 17:54:57
415	89	2022-08-09 17:54:57
415	90	2022-08-09 17:54:57
415	91	2022-08-09 17:54:57
415	92	2022-08-09 17:54:57
415	93	2022-08-09 17:54:57
415	94	2022-08-09 17:54:57
415	95	2022-08-09 17:54:57
415	96	2022-08-09 17:54:57
415	97	2022-08-09 17:54:57
415	98	2022-08-09 17:54:57
415	99	2022-08-09 17:54:57
415	100	2022-08-09 17:54:57