We are now beginning to learn MySQL, the following is a brief introduction to MySQL common commands
Copyright Skylinelin All, reproduced please indicate the source.
First log in to the MySQL database, "\h" look at the Help information
These are the common commands for MySQL.
Let's take a brief look at
Command |
Shorthand |
specific meaning |
? |
(\?) |
Display Help information |
Clear |
(\c) |
Explicit current input statement |
Connect |
(\ R) |
Connect to the server with optional parameters for database and host |
Delimiter |
(\d) |
Set Statement delimiter |
Ego |
(\g) |
Send commands to the MySQL server and display the results |
Exit |
(\q) |
Quit MySQL |
Go |
(\g) |
Send command to MySQL server |
Help |
(\h) |
Display Help information |
Notee |
(\ t) |
Do not write output file |
Print |
(\p) |
Print current command |
Prompt |
(\ R) |
Change MySQL tip information |
Quit |
(\q) |
Quit MySQL |
Rehash |
(\#) |
Rebuild Complete Hash |
Source |
(\.) |
Executes an SQL script file with a file name as a parameter |
Status |
(\s) |
Get MySQL status information from the server |
Tee |
(\ t) |
Sets the output file (output file) and adds the information to all given output files |
Use |
(\u) |
With another database, the database name as the parameter |
CharSet |
(\c) |
Switch to another character set |
Warnings |
(\w) |
Display a warning after each statement |
Nowarning |
(\w) |
Do not display a warning after each statement |
End
MySQL Related commands