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 |