MySQL Get help

To view configuration parameters:

SHOW VARIABLES like '%timeout% '

2) MySQL Client tool comes with help

? (\?) Synonym for ' help '.

Clear (\c) Clear the current input statement. --Clears the current input statement

Connect (\ r) reconnect to the server.  Optional arguments is DB and host. --reconnect, usually used to be removed or re-connected after an abnormal disconnection,

Delimiter (\d) Set statement delimiter. --Set the command terminator, by default, for example, we can set to/to indicate end of statement

Edit command with $EDITOR. \e. --Edit the previous SQL statement in the buffer to the file, the default call VI, the file will be placed in the/TMP path

Ego (\g) Send command to MySQL server, display result vertically. --control results displayed as vertical display

Exit (\q) exit MySQL.                   Same as quit. --Quit MySQL

Go (\g) Send command to MySQL server. --Send command to MySQL service

Help (\h) Display.

Nopager (\ n) Disable Pager, print to stdout. --Turn off page setup, print to standard output

Notee (\ t) Don ' t write into outfile. --Turn off output to file

Pager (\p) Set Pager [To_pager].    Print the query results via PAGER. --Set pager mode, can be set to call more,less and so on, mainly for paging display

Print (\p) print current command.

Prompt (\ r) Change your MySQL prompt. --Change the prompt for MySQL

Quit (\q) quit MySQL.

Rehash (\#) Rebuild completion hash. --Automatic completion of related object names

Source (\.) Execute an SQL script file. Takes a file name as an argument. --Execute script file

Status (\s) Get status information from the server. --Get status information

System (\!)                Execute a system shell command. --Execute system commands

Tee (\ t) Set outfile [To_outfile]. Append everything into given outfile.--operation results output to file

Use (\u) use another database.     Takes database name as argument. --Switch database

CharSet (\c) Switch to another charset. Might is needed for processing binlog with Multi-Byte charsets. --Set character sets

Warnings (\w) Show warnings after every statement. --Print warning message

Nowarning (\w) Don ' t show warnings after every statement.

3, the service side of the relevant help

---Get help with Server management, and enter contents

mysql> Help Contents;

MySQL Get help