MYSQL Getting Started: MYSQL Command Parameters

Source: Internet
Author: User
Tags rehash sql error x509 cert ssl connection


MYSQL Getting Started: Link to MYSQL command parameters: MYSQL Getting Started: basic operations http://www.bkjia.com/database/201212/173868.htmlMYSQL Entry 2: Search Using Regular Expressions http://www.bkjia.com/database/201212/173869.htmlMYSQL Entry 3: Full Text Search http://www.bkjia.com/database/201212/173873.htmlMYSQL Entry 4: MYSQL Data Types http://www.bkjia.com/database/201212/175536.htmlMYSQL Entry 5: MYSQL Character Set http://www.bkjia.com/database/201212/175541.htmlMYSQL Getting started 6: MYSQL Operators http://www.bkjia.com/database/201212/175862.htmlMYSQL Entry 7: MYSQL common functions http://www.bkjia.com/database/201212/175864.htmlMYSQL Step 8: basic database and table operations http://www.bkjia.com/database/201212/175867.htmlMYSQL 9: simple indexing operations http://www.bkjia.com/database/201212/176772.htmlMYSQL 10: basic view operations http://www.bkjia.com/database/201212/176775.htmlMYSQL Quick Start 11: Basic trigger operations http://www.bkjia.com/database/201212/176781.htmlMYSQL 12: basic operations of Stored Procedures http://www.bkjia.com/database/201212/177380.htmlMYSQL Step 13: basic operations for custom functions http://www.bkjia.com/database/201212/177382.htmlMYSQL 14: basic operations on cursors http://www.bkjia.com/database/201212/177384.htmlMYSQL Step 15: basic transaction processing operations http://www.bkjia.com/database/201212/177385.html 1. Detailed descriptions of MYSQL command line parameters www.2cto.com Usage: mysql [OPTIONS] [database] detailed descriptions of various OPTIONS are as follows :-?, -- Help: displays help information and exits-I. -- help: displays help information and exits -- auto-rehash: in linux, press the Tab key to display the prompt-, -- no-auto-rehash the default status does not have the auto-completion function. -A means not to automatically fill in full functions-B, -- batch mysql does not use historical files, disable interaction -- installation directory of character-sets-dir = name font set -- default-character-set = name to set the default character set of the database -- when the column-type-info result set is returned, at the same time, the field type and other related information-c, -- comments Preserve comments. send comments to the server. the default is -- skip-comments (discard comments), enable with -- comments-C, -- compress uses compression when The client and server transmit information -#, -- debug [= #] bug call function-D, -- database = name used database -- default-characte R-set = name set default character set -- delimiter = name set default command Terminator-e, -- execute = name run mysql SQL statement-E, -- vertical print query output-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, the named commands can be used from any line of the query, otherwise only from the first line, before an enter. disable with -- disable-na Med-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 with '-G '. long format commands still work from the first line. WARNING: option deprecated; use -- disable-named-commands instead. -I, -- ignore-spaces ignores spaces behind the function name. -- local-infile start/disable load data local infile. -B, -- no-beep SQL error, disable-h, -- host = name to set the name or Ip address of the Connected Server, -- html outputs-X in html format, -- xml outputs in xml format -- line-numbers displays the wrong row number-L, -- skip-line-numbers ignore the wrong row number-n, -- unbuffered refresh the cache after each SQL Execution -- Column-names: column information is displayed during query. By default,-N is added. -- skip-column-names does not display column information-O, -- set-variable = name: set-variable = var_name = var_value -- sigint-ignore ignores the SIGINT symbol (the result of Control-C Upon logon and exit)-o, -- one-database ignores statements in addition to 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, use more and less. -- No-pager does not use the page splitter to display query output. -P, -- password [= name] enter the password-W, -- pipe Use named pipes to connect to server. -P, -- port = # Set port -- prompt = name set mysql prompt -- protocol = name set the protocol used-q, -- quick does not cache query results, print each row in sequence. If the output is suspended, the server slows down and mysql does not use historical files. Www.2cto.com-r, -- raw writes column values without escape conversion. It is usually used in combination with the -- batch option. -- Reconnect automatically tries to reconnect if the connection is disconnected from the server. Disable reconnection and use -- disable-reconnect. -S, -- silent one line of output, with tabs in the middle to separate-S, -- socket = name to connect to the server's sockey file -- ssl to activate the ssl connection, disable -- skip-ssl -- ssl-ca = name CA file in PEM format (check OpenSSL docs, implies -- ssl ). -- ssl-capath = name CA directory (check OpenSSL docs, implies -- ssl ). -- ssl-cert = name X509 cert in PEM format (implies -- ssl ). -- ssl-cipher = name SSL cipher to use (implies -- ssl ). -- ssl-key = name X509 key in PEM format (implies -- ssl ). -- ss L-verify-server-cert checks the server certificate-t when connecting, -- table outputs in the form of a table -- tee = name to copy the output and add it to the given file, the -- disable-tee -- no-tee Root -- disable-tee function is the same as-u, -- user = name username-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 mysql statement-V, -- version-w, -- after the wait server is down, wait for the restart time -- connect_timeout = # Time to wait before connection -- max_allowed_packet = # server receives /The maximum length of the package -- net_buffer_length = # the size of the TCP/IP and socket communication buffer. -- Select_limit = # automatic restriction of SELECT statement when -- safe-updates is used -- max_join_size = # automatic restriction of rows in connection when -- safe-updates is used -- secure-auth reject (pre-4.1.1) connection to the database -- server-arg = name Sendembeddedserverthisasaparameter. -- show-warnings: Warning 2. Some examples of use [SQL] C: \ Users \ qxl> mysql-uroot-D test-e "show tables; "+ --------------------- + | Tables_in_test | + ----------------------- + | newname | productnotes | student | t_goods | C :\ Users \ qxl> mysql-uroot-D test-e "show tables;"-B Tables_in_test newname productnotes student t_goods C: \ Users \ qxl> mysql-uroot-D test -- default-character-set = gbk Welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 20 Server version: 5.1.28-rc-community MySQL Community Server (GPL) Type 'help; 'or' \ H' for help. type '\ C' to clear the buffer. mysql> show variabl Es like '% char % '; + bytes + | Variable_name | Value | + bytes + | character_set_client | gbk | character_set_connection | gbk | character_set_database | latin1 | bytes | binary | bytes | gbk | | character_set_server | latin1 | char Acter_set_system | utf8 | character_sets_dir | D: \ APMServ5.2.6 \ MySQL5.1 \ share \ charsets \ | + ---------------------- + bytes + C: \ Users \ qxl> mysql-uroot-D test -- delimiter = // Welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 21 Server version: 5.1.28-rc-community MySQL Community Server (GPL) Type 'help; 'or' \ H' for help. typ E' \ C' to clear the buffer. mysql> use test // Database changed mysql> select count (*) from test. newname // C: \ Users \ qxl> mysql-uroot-D mysql-e "show tables; "-H <table border = 1> <TR> <TH> Tables_in_mysql </TH> </TR> <TD> columns_priv </TD> </TR> <TR> <TD> db </TD> </TR> <TD> event </TD> </TR> <TD> func </TD> </TR> <TD> general_log </TD> </TR> <TD> help_category </TD> </TR> <TD> help_keyword </TD> </TR> <T R> <TD> help_relation </TD> </TR> <TD> help_topic </TD> </TR> <TD> host </TD> </TR> <TD> ndb_binlog_index </TD> </TR> <TD> plugin </TD> </TR> <TD> proc </TD> </TR> <TD> procs_priv </TD> </TR> <TD> servers </TD> </TR> <TR> <TD> slow_log </TD> </TR> <TD> tables_priv </TD> </TR> <TD> time_zone </TD> </TR> <TD> time_zone_leap_second </TD> </TR> <TD> time_zone_name </TD> </TR> <TD> time_zone_transition </T D> </TR> <TD> time_zone_transition_type </TD> </TR> <TD> user </TD> </TR> </TABLE> c: \ Users \ qxl> mysql-uroot-D mysql-e "show tables;"-X <? Xml version = "1.0"?> <Resultset statement = "show tables" xmlns: xsi =" http://www.w3.org/2001/XMLSchema-instance "> <Row> <field name =" Tables_in_mysql "> columns_priv </field> </row> <field name =" Tables_in_mysql "> db </field> </ row> <field name = "Tables_in_mysql"> event </field> </row> <field name = "Tables_in_mysql"> func </field> </ row> </resultset> www.2cto.com C: \ Users \ qxl> mysql-uroot-D mysql -- prompt = "this is my database! "Welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 27 Server version: 5.1.28-rc-community MySQL Community Server (GPL) Type 'help; 'or' \ H' for help. type '\ C' to clear the buffer. this is my database!

Related Article

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.