MySQL database learning three MySQL database basic operations

3.1 Databases and Data objects

1. System Database

• • INFORMATION_SCHEMA: Some database object information in the primary storage system, such as user list information, column information, permission information, character set information and partition information.
  • Performance_schema: Primary Storage Database server performance parameters.
  • MySQL: User rights information for the primary storage system.
  • Test: The database is tested and can be used by any user.

2. User Database

A database object is a different form of structure that stores, manages, and uses data, mainly including tables, views, stored procedures, functions, triggers, and events.

3.2 Database-related operations

1. Create a database

Create Database database_name;

2. View and select a database

SHOW DATABASES;

Use database_name;

3. Deleting a database

DROP DATABASE database_name

MySQL database learning three MySQL database basic operations