MySQL Common manual

1. How to log in to MySQL

Under Linux, use the command mysql-u ' your username '-p to enter. Enter your password to log in to MySQL

2. Show what database MySQL has

Use show databses on the MySQL command line; Commands to view

3. How to select a database

After displaying the database through show databases, you can select the database using the command use command. such as use test

4. How to view the table structure

Table structure can be viewed with the DESC command

5. Display the current login user

Through show user (); command to display the current user

6. Displaying the database that is currently in use

Through show database (); command to show which databases are currently in use

7. SQL Mood Classification

DDL: Data definition language, Create,drop,alter

DML: Data Manipulation language UPDATE, Insert,delete,select

DCL: Permission Language GRANT Revoke,commit,rollback

MySQL Common manual