概述

  • mysql.exe可以运行在 {交互模式|非交互模式}。在交互模式下，查询结果以ascii表的形式展现；在非交互模式下，可以通过选项来是查询结果以{tab分割的文本 | xml | html |等等}展现；非交互模式是通过管道转向来实现的！
  • 如果因为查询结果过大而致使内存不足问题出现：可以通过--quick选项逐行输出模式
  • mysql.exe可以识别的命令结束分隔符：";"、\g、\G
  • ctrl+c可以取消当前的查询语句 或者 退出！
  • {source|.\}可以执行脚本文件

 

命令

牛X的帮助命令：{ help | \h | ?}  可以获得几乎你想要的任何东西，就是更加简洁直接的参考手册，（应该是基于index的技术构造的）

 

?

(\?)

Synonym for `help'.

clear

(\c)

Clear command.

connect

(\r)

Reconnect to the server. Optional arguments are db and host.

delimiter

(\d)

Set statement delimiter.

ego

(\G)

Send command to mysql server, display result vertically.

exit

(\q)

Exit mysql. Same as quit.

go

(\g)

Send command to mysql server.

help

(\h)

Display this help.

notee

(\t)

Don't write into outfile.

print

(\p)

Print current command.

prompt

(\R)

Change your mysql prompt.

quit

(\q)

Quit mysql.

rehash

(\#)

Rebuild completion hash.

source

(\.)

Execute an SQL script file. Takes a file name as an argument.

status

(\s)

Get status information from the server.

tee

(\T)

Set outfile [to_outfile]. Append everything into given outfile.

use

(\u)

Use another database. Takes database name as argument.

charset

(\C)

Switch to another charset. Might be needed for processing binlog with multi-byte charsets.

warnings

(\W)

Show warnings after every statement.

nowarning

(\w)

Don't show warnings after every statement.

 

选项

Format Config File Description Introduction Deprecated Removed
--auto-rehash auto-rehash Enable automatic rehashing      
--batch batch Don't use history file      
--character-sets-dir=name character-sets-dir Set the default character set      
--column-names column-names Write column names in results      
--column-type-info column-type-info Display result set metadata 5.1.14    
--comments comments Whether to retain or strip comments in statements sent to the server 5.1.23    
--compress compress Compress all information sent between the client and the server      
--connect_timeout=value connect_timeout The number of seconds before connection timeout      
--database=dbname database The database to use      
--debug[=debug_options] debug Write a debugging log      
--debug-check debug-check Print debugging information when the program exits 5.1.21    
--debug-info debug-info Print debugging information, memory and CPU statistics when the program exits      
--default-character-set=charset_name default-character-set Use charset_name as the default character set      
--delimiter=str delimiter Set the statement delimiter      
--execute=statement execute Execute the statement and quit      
--force force Continue even if an SQL error occurs      
--help   Display help message and exit      
--host=host_name host Connect to the MySQL server on the given host      
--html html Produce HTML output      
--ignore-spaces ignore-spaces Ignore spaces after function names      
--line-numbers line-numbers Write line numbers for errors      
--local-infile[={0|1}] local-infile Enable or disable for LOCAL capability for LOAD DATA INFILE      
--max_allowed_packet=value max_allowed_packet The maximum packet length to send to or receive from the server      
--max_join_size=value max_join_size The automatic limit for rows in a join when using --safe-updates      
--named-commands named-commands Enable named mysql commands      
--net_buffer_length=value net_buffer_length The buffer size for TCP/IP and socket communication      
--no-auto-rehash   Disable automatic rehashing      
--no-beep no-beep Do not beep when errors occur      
--no-named-commands no-named-commands Disable named mysql commands      
--no-pager no-pager Deprecated form of --skip-pager      
--no-tee no-tee Do not copy output to a file      
--one-database one-database Ignore statements except those for the default database named on the command line      
--pager[=command] pager Use the given command for paging query output      
--password[=password] password The password to use when connecting to the server      
--port=port_num port The TCP/IP port number to use for the connection      
--prompt=format_str prompt Set the prompt to the specified format      
--protocol=type protocol The connection protocol to use      
--quick quick Do not cache each query result      
--raw raw Write column values without escape conversion      
--reconnect reconnect If the connection to the server is lost, automatically try to reconnect      
--safe-updates safe-updates Allow only UPDATE and DELETE statements that specify key values      
--secure-auth secure-auth Do not send passwords to the server in old (pre-4.1.1) format      
--select_limit=value select_limit The automatic limit for SELECT statements when using --safe-updates      
--show-warnings show-warnings Show warnings after each statement if there are any      
--sigint-ignore sigint-ignore Ignore SIGINT signals (typically the result of typing Control-C)      
--silent silent Silent mode      
--skip-auto-rehash skip-auto-rehash Disable automatic rehashing      
--skip-column-names skip-column-names Do not write column names in results      
--skip-line-numbers skip-line-numbers Skip line numbers for errors      
--skip-named-commands skip-named-commands Disable named mysql commands      
--skip-pager skip-pager Disable paging      
--skip-reconnect skip-reconnect Disable reconnecting      
--socket=path socket For connections to localhost      
--ssl-ca=file_name ssl-ca The path to a file that contains a list of trusted SSL CAs      
--ssl-capath=directory_name ssl-capath The path to a directory that contains trusted SSL CA certificates in PEM format      
--ssl-cert=file_name ssl-cert The name of the SSL certificate file to use for establishing a secure connection      
--ssl-cipher=cipher_list ssl-cipher A list of allowable ciphers to use for SSL encryption      
--ssl-key=file_name ssl-key The name of the SSL key file to use for establishing a secure connection      
--ssl-verify-server-cert ssl-verify-server-cert The server's Common Name value in its certificate is verified against the host name used when connecting to the server      
--table table Display output in tabular format      
--tee=file_name tee Append a copy of output to the given file      
--unbuffered unbuffered Flush the buffer after each query      
--user=user_name user The MySQL user name to use when connecting to the server      
--verbose   Verbose mode      
--version   Display version information and exit      
--vertical vertical Print query output rows vertically (one line per column value)      
--wait wait If the connection cannot be established, wait and retry instead of aborting      
--xml xml Produce XML output