MYSQL Getting Started: MYSQL Command Parameters

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!