云数据库 GaussDB-gs_loader:控制文件

时间：2025-01-26 10:37:37

云数据库 GaussDB

控制文件

语法说明：

    
         LOAD [ DATA ][CHARACTERSET char_set_name][INFILE [directory_path] [filename ] ][BADFILE [directory_path] [filename ] ][{ INSERT | APPEND | REPLACE | TRUNCATE }] INTO TABLE table_name[{ INSERT | APPEND | REPLACE | TRUNCATE }] [FIELDS  CS V][TERMINATED [BY] { 'string' }][OPTIONALLY ENCLOSED BY { 'string' }][TRAILING NULLCOLS][ WHEN { (start:end) | column_name } {= | !=} ‘string’ ][(col_name [ [ POSITION ({ start:end }) ]  ["sql_string"] ] | [ FILLER [column_type [external] ] ] | [ CONSTANT "string" ] | [ SEQUENCE ( { COUNT | MAX | integer } [, incr] ) ]|[NULLIF (COL=BLANKS)][, ...])]