LOAD DATA

语法说明

LOAD DATA语句以超快的速度从一个文本文件中读取数据然后存储到表中。

语法结构

1. > LOAD DATA
2. [LOW_PRIORITY | CONCURRENT] [LOCAL]
3. INFILE 'file_name'
4. [REPLACE | IGNORE]
5. INTO TABLE tbl_name
6. [PARTITION (partition_name [, partition_name] ...)]
7. [CHARACTER SET charset_name]
8. [{FIELDS | COLUMNS}
9. [TERMINATED BY 'string']
10. [[OPTIONALLY] ENCLOSED BY 'char']
11. [ESCAPED BY 'char']
12. ]
13. [LINES
14. [STARTING BY 'string']
15. [TERMINATED BY 'string']
16. ]
17. [IGNORE number {LINES | ROWS}]
18. [(col_name_or_user_var
19. [, col_name_or_user_var] ...)]
20. [SET col_name={expr | DEFAULT}
21. [, col_name={expr | DEFAULT}] ...]

* TERMINATED BY，ENCLOSED BY等分隔符的意义与SELECT INTO一致。 * IGNORE number可用来忽略从文件开始的第number行/列。

示例

可以在SSB测试中了解LOAD DATA语句的用法，请见 Complete a SSB Test with MatrixOne

1. > LOAD DATA INFILE '/ssb-dbgen-path/lineorder_flat.tbl ' INTO TABLE lineorder_flat;