语法:
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE | IGNORE] INTO TABLE 表名 [IGNORE number LINES] [ ( 列表 , ... ) ] |
参数:
参数 | 意义 |
---|---|
LOW_PRIORITY | 低优先级,等到表空闲时执行 |
CONCURRENT | 允许其他线程同时使用表 |
LOCAL | 从客户端读取文本文件 |
FIELDS | |
IGNORE number LINES | 忽略几行数据,一般为表头 |
[FIELDS
[TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES TERMINATED BY '\n'] |
参数:
参数 | 意义 |
---|---|
TERMINATED BY | 字段之间的间隔字符,一般为逗号,空格,制表符 |
ENCLOSED | 字段边界字符,一般为单引号,双引号 |
ESCAPED BY | 定义文本文件中的转义字符,一般为反斜杠 |
LINES TERMINATED BY | 记录之间的间隔字符,一般为换行 |