![](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FcLAC5u%2Fbtr2aJIHu5m%2FrHs4tMtQvacY6ywQKWYQr0%2Fimg.png)
SQL | MySQL | LOAD DATA INFILE - 파일 데이터 불러오기
·
SQL
LOAD DATA INFILE Syntax를 사용하면 대용량 데이터를 빠른 속도로 불러올 수 있다. LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE 만들어놓은테이블명 [CHARACTER SET charset_name] [ {FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [ LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number LINES] [(col_name_or_user_var,.....