mysql数据库创建、删除数据库

一、创建数据库（默认字符集和排序规则）

    （1）创建数据库

mysql> CREATE DATABASE my_db1;
Query OK, 1 row affected (0.00 sec)

    （2）因为my_db1已经存在，再次创建会报错

mysql> CREATE DATABASE my_db1;
ERROR 1007 (HY000): Can't create database 'my_db1'; database exists

mysql> CREATE DATABASE IF NOT EXISTS my_db1;
Query OK, 1 row affected, 1 warning (0.00 sec)

二、创建数据库包含字符集和排序规则

（1）查看mysql字符集

mysql> SHOW CHARACTER SET;
+----------+-----------------------------+---------------------+--------+
| Charset
| Description
| Default collation
| Maxlen |
+----------+-----------------------------+---------------------+--------+
| big5
| Big5 Traditional Chinese
| big5_chinese_ci
|
2 |
| dec8
| DEC West European
| dec8_swedish_ci
|
1 |
| cp850
| DOS West European
| cp850_general_ci
|
1 |
| hp8
| HP West European
| hp8_english_ci
|
1 |
| koi8r
| KOI8-R Relcom Russian
| koi8r_general_ci
|
1 |
| latin1
| cp1252 West European
| latin1_swedish_ci
|
1 |
.......

mysql> SHOW COLLATION;
+--------------------------+----------+-----+---------+----------+---------+
| Collation
| Charset
| Id
| Default | Compiled | Sortlen |
+--------------------------+----------+-----+---------+----------+---------+
| big5_chinese_ci
| big5
|
1 | Yes
| Yes
|
1 |
| big5_bin
| big5
|
84 |
| Yes
|
1 |
| dec8_swedish_ci
| dec8
|
3 | Yes
| Yes
|
1 |
| dec8_bin
| dec8
|
69 |
| Yes
|
1 |
| cp850_general_ci
| cp850
|
4 | Yes
| Yes
|
1 |
| cp850_bin
| cp850
|
80 |
| Yes
|
1 |
| hp8_english_ci
| hp8
|
6 | Yes
| Yes
|
1 |
.................

mysql> CREATE DATABASE IF NOT EXISTS hdu CHARACTER SET 'gbk' COLLATE 'gbk_chinese_ci';
Query OK, 1 row affected (0.00 sec)

三、删除数据库

mysql> DROP DATABASE my_db1;
Query OK, 0 rows affected (0.00 sec)

最后

以上就是贪玩小海豚为你收集整理的mysql数据库创建、删除数据库的全部内容，希望文章能够帮你解决mysql数据库创建、删除数据库所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。