MySQL database create, delete database

I. Creating a database (default character set and collation)

(1) Create a database

[SQL]View PlainCopy

1. mysql> CREATE DATABASE my_db1;
2. Query OK, 1 row Affected (0.00 sec)

(2) Because MY_DB1 already exists, create an error again

[SQL]View PlainCopy

1. mysql> CREATE DATABASE my_db1;
2. ERROR 1007 (HY000): Can' t create database ' MY_DB1 '; Database exists

(4) plus if not exists even if the database already exists, the original cover out

[SQL]View PlainCopy

1. mysql> CREATE DATABASE IF not EXISTS my_db1;
2. Query OK, 1 row affected, 1 Warning (0.00 sec)

Ii. creating a database containing character sets and collations

(1) View MySQL character set

[SQL]View PlainCopy

2. mysql> SHOW CHARACTER SET;
4. +----------+-----------------------------+---------------------+--------+  
6. | Charset | Description | Default Collation |  MaxLen |
8. +----------+-----------------------------+---------------------+--------+  
10. | Big5 | Big5 Traditional Chinese |      Big5_chinese_ci | 2 |
12. | Dec8 |      DEC West European | dec8_swedish_ci |  1 |
14. | cp850 | DOS West European |      Cp850_general_ci | 1 |
16. | HP8 | HP West European |      Hp8_english_ci | 1 |
18. | koi8r | Koi8-r relcom Russian |      Koi8r_general_ci | 1 |
20. | Latin1 | cp1252 West European |      Latin1_swedish_ci | 1 |
22. .......

(2) View MySQL collation

[SQL]View PlainCopy

2. Mysql> SHOW COLLATION;
4. +--------------------------+----------+-----+---------+----------+---------+  
6. | Collation | Charset | Id | Default | Compiled |  Sortlen |
8. +--------------------------+----------+-----+---------+----------+---------+  
10. | Big5_chinese_ci |   Big5 | 1 | Yes |       Yes | 1 |
12. | Big5_bin |  Big5 |         84 | |       Yes | 1 |
14. | Dec8_swedish_ci |   Dec8 | 3 | Yes |       Yes | 1 |
16. | Dec8_bin |  Dec8 |         69 | |       Yes | 1 |
18. | Cp850_general_ci |   cp850 | 4 | Yes |       Yes | 1 |
20. | Cp850_bin |  cp850 |         80 | |       Yes | 1 |
22. | Hp8_english_ci |   HP8 | 6 | Yes |       Yes | 1 |
24. .................

(3) Create database including character set and collation

[SQL]View PlainCopy

1. mysql> CREATE DATABASE IF not EXISTS hdu CHARACTER SET ' gbk ' COLLATE ' gbk_chinese_ci ';
2. Query OK, 1 row Affected (0.00 sec)

Third, delete the database

[SQL]View PlainCopy

1. mysql> DROP DATABASE my_db1;
2. Query OK, 0 rows Affected (0.00 sec)

MySQL database create, delete database