Commonly used MySql Command column selection, mysql Command Column

Source: Internet
Author: User

Commonly used MySql Command column selection, mysql Command Column

Select common MySql Command Columns
Command Parameters Description
Alter Databases and tables Modify database or table
Backup Table Backup table
\ C   Cancel Input
Create Databases and tables Create a database or table
Delete Table and row expressions Delete rows from a table
Describe Table Description table columns
Drop Databases and tables Delete a database or table
Exit (ctrl + c)   Exit
Grant User Information Modify user permissions
Help (\ h ,\?) Project Show project help
Insert Data expression Insert data
Lock (unlock)   Lock table (unlock table)
Quit (\ q)   Similar to exit
Rename Table Rename a table
Show Too many projects that cannot be listed List Project Descriptions
Sourc File Name Execute Command from File Name
Status (\ s)   Show current status
Truncate Table Clear table
Update Data expression Update existing data
Use Database Open Database

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.