openGauss这么多工具？到底要选哪个？（54）

#openGauss #入门 #安装 #数据库 #开源

知识来源：docs-opengauss.osinfra.cn/zh/

控制文件

• 语法说明：

  LOAD [ DATA ]
  [CHARACTERSET char_set_name]
  [INFILE [directory_path] [filename ] ]
  [BADFILE [directory_path] [filename ] ]
  [OPTIONS(name=value)]
  [{ INSERT | APPEND | REPLACE | TRUNCATE }] 
  INTO TABLE table_name
  [{ INSERT | APPEND | REPLACE | TRUNCATE }] 
  [FIELDS CSV]
  [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)]
  [, ...]
  )]
  

#openGauss #入门 #安装 #数据库 #开源

知识来源：docs-opengauss.osinfra.cn/zh/