Skip to content

Latest commit

 

History

History
79 lines (69 loc) · 3.78 KB

ksql.md

File metadata and controls

79 lines (69 loc) · 3.78 KB
Raw

命令行客户端ksql

  • ksql是KingbaseES的交互终端，也就是命令行客户端，其作用类似于Oracle的sqlplus。

  • 快捷键

    • tab键可以进行命令补全
    • ↑ ↓ 键可以翻阅历史命令
    • ? 可以查看元命令帮助
    • \h 可以查看SQL帮助
    • 可以使用 * 或 ？ 通配符

  • ksql参数

      D:\Program Files\Kingbase\ES\V8\Server\bin>ksql --help
  ksql is the Kingbase interactive terminal.
  
  Usage:
    ksql [OPTION]... [DBNAME [USERNAME]]
  
  General options:
    -c, --command=COMMAND    run only single command (SQL or internal) and exit
    -d, --dbname=DBNAME      database name to connect to (default: "Administrator")
    -f, --file=FILENAME      execute commands from file, then exit
    -l, --list               list available databases, then exit
    -v, --set=, --variable=NAME=VALUE
                             set ksql variable NAME to VALUE
                             (e.g., -v ON_ERROR_STOP=1)
    -V, --version            output version information, then exit
    -X, --no-ksqlrc          do not read startup file (~/.ksqlrc)
    -1 ("one"), --single-transaction
                             execute as a single transaction (if non-interactive)
    -?, --help[=options]     show this help, then exit
        --help=commands      list backslash commands, then exit
        --help=variables     list special variables, then exit
  
  Input and output options:
    -a, --echo-all           echo all input from script
    -b, --echo-errors        echo failed commands
    -e, --echo-queries       echo commands sent to server
    -E, --echo-hidden        display queries that internal commands generate
    -L, --log-file=FILENAME  send session log to file
    -n, --no-readline        disable enhanced command line editing (readline)
    -o, --output=FILENAME    send query results to file (or |pipe)
    -q, --quiet              run quietly (no messages, only query output)
    -s, --single-step        single-step mode (confirm each query)
    -S, --single-line        single-line mode (end of line terminates SQL command)
  
  Output format options:
    -A, --no-align           unaligned table output mode
        --csv                CSV (Comma-Separated Values) table output mode
    -F, --field-separator=STRING
                             field separator for unaligned output (default: "|")
    -H, --html               HTML table output mode
    -P, --pset=VAR[=ARG]     set printing option VAR to ARG (see \pset command)
    -R, --record-separator=STRING
                             record separator for unaligned output (default: newline)
    -t, --tuples-only        print rows only
    -T, --table-attr=TEXT    set HTML table tag attributes (e.g., width, border)
    -x, --expanded           turn on expanded table output
    -z, --field-separator-zero
                             set field separator for unaligned output to zero byte
    -0, --record-separator-zero
                             set record separator for unaligned output to zero byte
  
  Connection options:
    -h, --host=HOSTNAME      database server host or socket directory (default: "local socket")
    -p, --port=PORT          database server port (default: "54321")
    -U, --username=USERNAME  database user name (default: "Administrator")
    -w, --no-password        never prompt for password
    -W, --password           force password prompt (should happen automatically)
  
  For more information, type "\?" (for internal commands) or "\help" (for SQL
  commands) from within ksql, or consult the ksql section in the Kingbase
  documentation.
  
  Report bugs to <kingbase-bugs@kingbase.com.cn>.

  • 恢复.sql文件

      ksql -h 127.0.0.1 -p 54322 -U SYSTEM -W  -d infra_facility -f .\infra_facility_all_bck_DB_2023-09-16_12_56_40.sql

  • 连接某个库

      ksql.exe -h 127.0.0.1 -p 54326 -U system db_name