云数据库 GaussDB-使用LOAD DATA导入本地数据:语法

时间:2023-11-01 16:16:40

语法

LOAD DATA LOCAL    INFILE 'file_name'    [REPLACE | IGNORE]    INTO TABLE tbl_name    [CHARACTER SET charset_name]    [{FIELDS | COLUMNS}        [TERMINATED BY 'string']        [[OPTIONALLY] ENCLOSED BY 'char']    ]    [LINES        [TERMINATED BY 'string']    ]    [IGNORE number {LINES | ROWS}]    [(col_name_or_user_var        [, col_name_or_user_var] ...)]
support.huaweicloud.com/gaussdb_faq/gaussdb_faq_0145.html