MySQL Related commands

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.