Mysql command line parameters, python command line parameters

Source: Internet
Author: User
Tags rehash sql error mysql command line ssl connection

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.