데이터베이스-영화사이트 구축 실습

출처| https://www.youtube.com/watch?v=UVY0mfa4VP0&list=PLqTUMsvO70nk8WfCyU-IPmc85390CaSqM&index=1

https://cafe.naver.com/thisisMySQL
https://velog.io/@ong_hh/%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%B2%A0%EC%9D%B4%EC%8A%A4-%EA%B5%AC%EC%B6%95

CREATE DATABASE moviedb;

USE moivedb;
CREATE TABLE movietbl
(movie_id 	int,
 movie_title varchar(30),
 movie_director varchar(20),
 movie_star		varchar(20),
 movie_script	Longtext, -- 영화대본
 movie_film		Longblob
 ) DEFAULT CHARSET = utf8mb4;
 
 
 insert into movietbl value(1,'쉰들러리스트','스필버그','리암 니슨',
	LOAD_FILE('C:/SQL/Movies/Schindler.txt'),
    LOAD_FILE('C:/SQL/Movies/Schindler.mp4'));
    
SELECT * FROM movietbl;

SHOW variables LIKE 'max_allowed_packet';    
SHOW variables LIKE 'secure_file_priv';    

cmd 창 설정 후

USE moviedb;
truncate movietbl;

 insert into movietbl value(1,'쉰들러리스트','스필버그','리암 니슨',
	LOAD_FILE('C:/SQL/Movies/Schindler.txt'),
    LOAD_FILE('C:/SQL/Movies/Schindler.mp4'));
    
 insert into movietbl value(2,'쇼생크 탈출','프랭크 다라본트','링 로반스',
	LOAD_FILE('C:/SQL/Movies/Schindler.txt'),
    LOAD_FILE('C:/SQL/Movies/Schindler.mp4'));


 insert into movietbl value(3,'리스트 모히칸','마이클 만','다니엘 데이 루이스',
	LOAD_FILE('C:/SQL/Movies/Schindler.txt'),
    LOAD_FILE('C:/SQL/Movies/Schindler.mp4'));
    
select * from movietbl;

select movie_script from movietbl where movie_id = 1 
	into outfile 'c:/sql/Movies/Schindler_out.txt' -- 이 파일로 내려받아진다.
    lines terminated by '\\n'; -- 줄바꿈 
    
select movie_film from movietbl where movie_id = 3
	into dumpfile 'c:/sql/Movies/mohican_out.mp4';