概述
- 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. |
| | (\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 |