Mysql command line parameters, python command line parameters
1. mysql command line parameters
Usage: mysql [OPTIONS] [database] // command Method
-?, -- Help // display help information and exit
-I, -- help // display help information and exit
-- Auto-rehash // The auto-complement function is similar to the prompt by pressing the Tab key in linux. The following is an example.
-A, -- no-auto-rehash // The default status does not have the auto-completion function. -A does not automatically complete the function.
-B, -- batch // ysql does not use history files, disable Interaction
(Enables -- silent)
-- Character-sets-dir = name // installation directory of the font set
-- Default-character-set = name // sets the default character set of the database.
-C, -- compress // use compression when the client and server transmit information
-#, -- Debug [= #] // bug call Function
-D, -- database = name // which database to use
-- Delimiter = name // The default mysql Command Terminator is a semicolon. The following is an example:
-E, -- execute = name // execute the mysql SQL statement
-E, -- vertical // print the query output vertically
-F, -- force // if an error exists, continue to execute the following
-G, -- named-commands
/* Enable named commands. Named commands mean this program's
Internal commands; see mysql> help. When enabled,
Named commands can be used from any line of the query,
Otherwise only from the first line, before an enter.
Disable with -- disable-named-commands. This option is
Disabled by default .*/
-G, -- no-named-commands
/* Named commands are disabled. Use \ * form only, or use
Named commands only in the beginning of a line ending
With a semicolon (;) Since version 10.9 the client now
Starts with this option ENABLED by default! Disable
'-G'. Long format commands still work from the first
Line. WARNING: option deprecated; use
-- Disable-named-commands instead .*/
-I, -- ignore-spaces // ignore the space behind the function name.
-- Local-infile // start/disable load data local infile.
-B, -- no-beep // when an SQL error occurs, you are not allowed to beep.
-H, -- host = name // set the name or Ip address of the Connected Server
-H, -- html // output in html Format
-X, -- xml // output in xml format
-- Line-numbers // display the wrong row number
-L, -- skip-line-numbers // ignore the wrong row number
-N, -- unbuffered // refresh the cache after each SQL statement is executed
-- Column-names // column information is displayed during query. The column information is added by default.
-N, -- skip-column-names // The column information is not displayed.
-O, -- set-variable = name // set the variable usage to -- set-variable = var_name = var_value
-- Sigint-ignore // ignore SIGINT (result of Control-C Upon logon Exit)
-O, -- one-database // ignore statements except for the default database named in the command line. It can help skip updates of other databases in the log.
-- Pager [= name] // use the page splitter to display the query output. in linux, you can use more or less.
-- No-pager // no page splitter is used to display query output.
-P, -- password [= name] // enter the password
-P, -- port = # // set the port
-- Prompt = name // set the mysql prompt
-- Protocol = name // protocol used
-Q, -- quick // do not cache the query results and print each row in sequence. If the output is suspended, the server slows down and mysql does not use historical files.
-R, -- raw // write column values without escape conversion. It is usually used in combination with the -- batch option.
-- Reconnect // If the connection is disconnected from the server, the system automatically tries to reconnect. Disable reconnection and use -- disable-reconnect.
-S, -- silent // one line of output, separated by tabs
-S, -- socket = name // connect to the server's sockey File
-- Ssl // activate the ssl connection and disable -- skip-ssl
-- Ssl-ca = name // CA certificate
-- Ssl-capath = name // CA path
-- Ssl-cert = name // X509 Certificate
-- Ssl-cipher = name // SSL cipher to use (implies -- ssl ).
-- Ssl-key = name // X509 key name
-- Ssl-verify-server-cert // audit the server certificate when connecting
-T, -- table // output as a table
-- Tee = name // Add the output copy to the specified file. -- disable-tee is used when the file is disabled.
-- No-tee // The root -- disable-tee function is the same
-U, -- user = name // user name
-U, -- safe-updates // Only allow UPDATE and DELETE that uses keys.
-U, -- I-am-a-dummy // Synonym for option -- safe-updates,-U.
-V, -- verbose // output the statement executed by mysql
-V, -- version // version information
-W, -- wait // wait for the restart time after the server is down
-- Connect_timeout = # // time to wait before connection
-- Max_allowed_packet = # // Maximum length of the server receiving/sending package
-- Net_buffer_length = # // size of the TCP/IP and socket communication buffer.
-- Select_limit = # // automatic restriction of the SELECT statement when -- safe-updates is used
-- Max_join_size = # // use -- safe-updates to automatically restrict the rows in the connection
-- Secure-auth // refuse to connect to the database in the (pre-4.1.1) Way
-- Server-arg = name // Send embedded server this as a parameter.
-- Show-warnings // display warning