MySQL Library operations

I. Introduction to the Library

INFORMATION_SCHEMA: Virtual library, do not occupy disk space, storage is the database startup parameters, such as user table information, column information, permission information, character information and so on Performance_schema:mysql 5.5 Start a new database: Mainly used to collect database server performance parameters, record the processing of query requests occurred in various events, locks and other phenomena MySQL: Authorization library, the primary storage System user's permissions information test:mysql database system automatically created test database

Second, increase

1 syntax (help CREATE DATABASE)

CREATE database name CharSet UTF8;

2 Database naming rules:

can be by letter, number, underscore, @, #, $ case-sensitive uniqueness cannot use keywords such as create select cannot use the number maximum 128 bits alone

3 Examples:

mysql> CREATE DATABASE Blog_test; Query OK, 1 row affected (0.03 sec)

Third, check

1 View all databases

Mysql> Show databases;+--------------------+| Database           |+--------------------+| information_schema | | blog_test          | | db1                | | DB2                | | Liuyanban          | | MySQL              | | performance_schema | | Sakila             | | Test               | | World              |+--------------------+10 rows in Set (0.00 sec)

2 Viewing the creation information for a specified database (code)

Mysql> Show CREATE Database blog_test;+-----------+------------------------------------------------------------ --------+| Database  | Create Database                                                    |+-----------+--------------------------------------------------------------------+| blog_ Test | CREATE DATABASE ' blog_test '/*!40100 DEFAULT CHARACTER SET UTF8 */|+-----------+-------------------------------------- ------------------------------+1 Row in Set (0.00 sec)

Iv. Change of

1 modifying the encoding format of a database

mysql> ALTER DATABASE blog_test charset = UTF8; Query OK, 1 row Affected (0.00 sec)

V. Deletion of

mysql> drop Database blog_test; Query OK, 0 rows affected (0.14 sec)

　　

MySQL Library operations