MySQL LOAD DATA INFILE
LOAD DATA INFILE语句是MySQL中用来批量、快速导入数据的一种方式,和SELECT ... INTO OUTFILE 作用是相反的
一、完整语法
- LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
- [REPLACE | IGNORE]
- INTO TABLE tbl_name
- [PARTITION (partition_name,...)]
- [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 | ROWS}]
- [(col_name_or_user_var,...)] </