home / sakila

film_actor

29 rows where actor_id = 5

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update, last_update (date)

Link actor_id film_id last_update
5,19 5 5 AMADEUS HOLY 19 2020-12-23 07:13:44
5,54 5 5 BANGER PINOCCHIO 54 2020-12-23 07:13:44
5,85 5 5 BONNIE HOLOCAUST 85 2020-12-23 07:13:45
5,146 5 5 CHITTY LOCK 146 2020-12-23 07:13:45
5,171 5 5 COMMANDMENTS EXPRESS 171 2020-12-23 07:13:45
5,172 5 5 CONEHEADS SMOOCHY 172 2020-12-23 07:13:45
5,202 5 5 DADDY PITTSBURGH 202 2020-12-23 07:13:45
5,203 5 5 DAISY MENAGERIE 203 2020-12-23 07:13:45
5,286 5 5 ENOUGH RAGING 286 2020-12-23 07:13:45
5,288 5 5 ESCAPE METROPOLIS 288 2020-12-23 07:13:45
5,316 5 5 FIRE WOLVES 316 2020-12-23 07:13:45
5,340 5 5 FRONTIER CABIN 340 2020-12-23 07:13:45
5,369 5 5 GOODFELLAS SALUTE 369 2020-12-23 07:13:45
5,375 5 5 GRAIL FRANKENSTEIN 375 2020-12-23 07:13:45
5,383 5 5 GROOVE FICTION 383 2020-12-23 07:13:45
5,392 5 5 HALL CASSIDY 392 2020-12-23 07:13:45
5,411 5 5 HEAVENLY GUN 411 2020-12-23 07:13:45
5,503 5 5 KRAMER CHOCOLATE 503 2020-12-23 07:13:45
5,535 5 5 LOVE SUICIDES 535 2020-12-23 07:13:45
5,571 5 5 METAL ARMAGEDDON 571 2020-12-23 07:13:45
5,650 5 5 PACIFIC AMISTAD 650 2020-12-23 07:13:45
5,665 5 5 PATTON INTERVIEW 665 2020-12-23 07:13:45
5,687 5 5 POCUS PULP 687 2020-12-23 07:13:45
5,730 5 5 RIDGEMONT SUBMARINE 730 2020-12-23 07:13:45
5,732 5 5 RINGS HEARTBREAKERS 732 2020-12-23 07:13:45
5,811 5 5 SMILE EARRING 811 2020-12-23 07:13:45
5,817 5 5 SOLDIERS EVOLUTION 817 2020-12-23 07:13:45
5,841 5 5 STAR OPERATION 841 2020-12-23 07:13:45
5,865 5 5 SUNRISE LEAGUE 865 2020-12-23 07:13:45

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE film_actor (
  actor_id INT NOT NULL,
  film_id  INT NOT NULL,
  last_update TIMESTAMP NOT NULL,
  PRIMARY KEY  (actor_id,film_id),
  CONSTRAINT fk_film_actor_actor FOREIGN KEY (actor_id) REFERENCES actor (actor_id) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT fk_film_actor_film FOREIGN KEY (film_id) REFERENCES film (film_id) ON DELETE NO ACTION ON UPDATE CASCADE
);
CREATE INDEX idx_fk_film_actor_film ON film_actor(film_id)
;
CREATE INDEX idx_fk_film_actor_actor ON film_actor(actor_id) 
;
Powered by Datasette · Queries took 8.815ms