clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 582722 fiddles created (13321 in the last week).

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 );
 hidden batch(es)


CREATE TABLE film ( film_id int auto_increment not null primary key, title char(45) NOT NULL, last_update timestamp DEFAULT now() NOT NULL );
 hidden batch(es)


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) );
 hidden batch(es)


CREATE INDEX idx_film_actor_a_f ON film_actor(actor_id, film_id)
 hidden batch(es)


SET SESSION cte_max_recursion_depth = 1000000;
 hidden batch(es)


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;
 hidden batch(es)


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;
 hidden batch(es)


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;
 hidden batch(es)


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