load data infile
-
[MYSQL]import CSV to MYSQL카테고리 없음 2013. 7. 17. 19:30
1. CSV를 입력받을 테이블을 작성 2. MYSQL에서 아래의 명령어를 실행mysql> load data infile "파일의절대경로/파일명.csv" into table 테이블명 fields terminated by ',' lines terminated by '"' 3 - 0 . 성공mysql> load data infile "파일의절대경로/파일명.csv" into table 테이블명 fields terminated by ',' lines terminated by '"';Query OK, 3 rows affected (0.00 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 3 - 1 . 실패1ERROR 13 (HY000): Can't get stat of '/..