MySQL Basics-Creating databases and tables

MySQL Basics-Creating databases and tables

Show Database list show databases; (SQL command itself is case-insensitive)

mysql> show databases;

Database

Information_schema

Mysql

Test

Summary: Information_schema database, also known as information architecture, manages the database composition information from the table, and the user management information retrieval dedicated database. Confirm that these database contents can grasp the state of the current database. Data that users use frequently cannot be saved in the MySQL and Information_shema databases. The final test database is the database used for testing, and installing MySQL automatically creates the test database and the database itself is empty.

MySQL Basics-Creating databases and tables