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