삽질예방/mysql
파일에서 읽어오기
Kwang-sung Jun
2008. 1. 14. 21:28
comma separate value 파일에서 읽어오기
load data local infile './netflix_csv_data/mapping.csv' into
table <table_name>
fields terminated by ','
lines terminated by '\n'
(<col_1>, <col_2>);
load data local infile './netflix_csv_data/mapping.csv' into
table <table_name>
fields terminated by ','
lines terminated by '\n'
(<col_1>, <col_2>);