MySQL命令行工具开发 2021-01-06

• 离线解析MySQL SQL文本生成语法树：

# ./gosqltree --help
sqltree version: 1.0.0
Usage: sqltree [--sql sqltext] [--all] [--id] [--element] [--origin] [--pretty]

Options:
  -all
        Print ALL.
  -element
        Print SQL element.
  -id
        Print SQL ID.
  -origin
        Print the original SQL syntax tree.
  -pretty
        Print pretty JSON.
  -sql string
        SQL text.

• MySQL大表DROP工具：

# ./gobigdrop --help
gobigdrop version: 1.0.0
Usage: gobigdrop [--host host] [--port port] [--user user] [--password password] [--db database] [--table table] [--log logfile] [--level loglevel] [--askpass]

Options:
  -askpass
        ask MySQL password.
  -db string
        MySQL database.
  -host string
        MySQL host.
  -level string
        gobigdrop log level. (default "INFO")
  -log string
        gobigdrop log file. (default "os.Stdout")
  -password string
        MySQL password.
  -port int
        MySQL port. (default 3306)
  -table string
        MySQL table.
  -user string
        MySQL user.