LOAD DATA

Description

The LOAD DATA statement reads rows from a text file into a table at a very high speed.

Syntax

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}] ...]

Examples

The SSB Test is an example of LOAD DATA syntax. Complete a SSB Test with MatrixOne

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