MySQL basics-creating databases and tables

MySQL basics-creating databases and tables

MySQL basics-creating databases and tables

Show database overview show databases; (SQL commands are case insensitive)

Mysql> show databases;

Database

Information_schema

Mysql

Test

Summary: The information_schema database, also known as the information architecture, manages the composition information of the database starting from the table and the retrieval of user management information. Confirm the content of these databases to know the status of the current database. You cannot store frequently used data in mysql and information_shema databases. The test database is used for testing. when mysql is installed, the test database is automatically created. The database itself is empty.