MySQL Database common operations

1. Database connection and shutdown: Mysql-h Server host address-u user name-P user Password

2. Create a new user and authorize: Grant permissions on the database. Data table to username @ Login host identified by "password"
3. Creating database: Create databases [if not exists] database name;

4. Delete database: Drop database [if exists] name;

5. Display database: show databases;

6. Open database is currently used: use database name;
   

7. To create a data table:

8. See how many tables the current database has: show tables;

9. View data table structure: DESC table name;

10. Delete data table: drop table name;
    

11. Inserting row Records into a datasheet (insert)

12. Querying data records from a data table (SELECT)

13. Change the records that exist in the data table (UPDATE)

14. Delete a record in a data table (delete)

　　　　

MySQL Database common operations