C:\Documents and Settings\perton>mysql -hlocalhost -uroot -p****
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 6.0.4-alpha-community-log MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> \h
For information about MySQL products and services, visit:http://www.mysql.com/
For developer information, including the MySQL Reference Manual, visit:http://dev.mysql.com/
To buy MySQL Network Support, training, or other products, visit:https://shop.mysql.com/
List of all MySQL commands:
Note that all text commands must be first on line and end with ';'
| ? | (\?) | Synonym for `help'. |
| clear | (\c) | Clear command. |
| connect | (\r) | Reconnect to the server. Optional arguments are db and host. |
| delimiter | (\d) | Set statement delimiter. NOTE: Takes the rest of the line as new 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. |
For server side help, type 'help contents'
mysql>
