MySQL display command, mysql display command

MySQL display command, mysql display command

Although various graphical management tools facilitate MySQL management, you may need to manually enter commands for ease of use. The following commands are excerpted for your own use.

1. display the Database List.
Show databases;
2. display the data tables in the database:
Use mysql;
Show tables;
3. display the data table structure:
Describe table name;
4. database creation:
Create database name;
5. Create a table:
Use Database Name;
Create table Name (field setting list );
6. Delete databases and tables:
Drop database name;
Drop table name;
7. Clear records in the table:
Delete from table name;
8. Display records in the table:
Select * from Table Name