actors.sql

CREATE TABLE IF NOT EXISTS actors (
  id SMALLINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  firstname VARCHAR(25) NOT NULL,
  lastname VARCHAR(25) NOT NULL,
  born DATE
);

INSERT INTO actors(firstname, lastname, born) VALUES("Ralph", "Fiennes", "1962-12-22");
INSERT INTO actors(firstname, lastname, born) VALUES("Léa", "Seydoux", "1985-07-01");
INSERT INTO actors(firstname, lastname, born) VALUES("Ben", "Wishaw", "1980-10-14");
INSERT INTO actors(firstname, lastname, born) VALUES("Vince", "Vaughn", "1970-03-28");
INSERT INTO actors(firstname, lastname, born) VALUES("Mara", "Wilson", "1987-07-24");
INSERT INTO actors(firstname, lastname, born) VALUES("Danny", "DeVito", "1944-11-17");
INSERT INTO actors(firstname, lastname, born) VALUES("Pam", "Ferris", "1948-05-11");