MySQL Database related operations

1. Create a database

CREATE DATABASE  []db_name[  [DEFAULT]CHARACTERSET  [=] [DEFAULT] [=  ] collation_name];

[] means you can omit

Example:

CREATE DATABASE IF  not EXISTSDb1DEFAULT CHARACTER SETUTF8;CREATE DATABASE IF  not EXISTSDb2DEFAULT CHARACTER SETGbkDEFAULTCOLLATE gbk_chinese_ci;CREATE DATABASEDB3;--Use the default character set

For the character set and the default collation, you can use SHOW CHARACTER set; To view.

Where: UTF8 corresponds to Utf8_general_ci, GBK corresponds to Gbk_chinese_ci, gb2312 corresponds to Gb2312_chinese_ci

2. Deleting a database

DROP DATABASE  [IF EXISTS] db_name

Example:

DROP DATABASE db1; DROP DATABASE IF EXISTS db1;

3. Display all databases on the MySQL database server side

SHOW DATABASES;

4. Using the database

 Use db_name;

5. Display a database definition

CREATE DATABASE db_name;

6. Get the currently used database name

SELECT DATABASE ();

7. Modifying the character set and collation used by the database

ALTER DATABASE  db_name  [  [DEFAULT]CHARACTERSET[=] CharSet _name]  [[  DEFAULT][=] collation_name]

Example:

ALTER DATABASE DEFAULT CHARACTER SET SET Gbk_bin;

View the warning messages from the previous action:

SHOW WARNINGS;

MySQL Database related operations