MySQL: library operations

A system database

INFORMATION_SCHEMA: Virtual library, do not occupy disk space, storage is the database startup parameters, such as user table information, column information, permissions information, character information.

Performance_schema:mysql 5.5 started a new database: Mainly used to collect database server performance parameters, record the processing of query requests occurred in various events, lock phenomenon.

MySQL: Authorization library, access information for primary storage system users

Test:mysql Database System Auto-created test database

Two Create a database

1 syntax (help CREATE DATABASE)

Create database name CharSet UTF8;

2 Database naming rules:

Select You cannot use the maximum number of 128 digits alone

Three database related operations

1 : View database show databases;show CREATE database db1; Select database (); 2 : Select database use database name 3 : Delete database drop databases name 4 : Alter DATABASE DB1 charset UTF8;

MySQL: library operations