MaoYan电影库数据库备份

-- MaoYan电影库数据库备份
-- 生成时间：2021-09-22
-- 作者：IT专家

/*
数据表：
film_info: 电影信息表
actor_info: 演员信息表
director_info: 导演信息表
*/

-- 数据库导出命令：mysqldump -p dbname > MaoYanFilmStorehouse.sql

-- film_info表
SELECT film_id, film_name, release_year, rating
FROM film_info;

-- actor_info表
SELECT actor_id, actor_name, gender, birthdate
FROM actor_info;

-- director_info表
SELECT director_id, director_name, gender, birthdate
FROM director_info;