04.数据库的创建

最新推荐文章于 2021-10-10 21:52:02 发布

张风捷特烈

最新推荐文章于 2021-10-10 21:52:02 发布

阅读量121

点赞数

分类专栏： MySQL

本文链接：https://blog.csdn.net/qq_30447263/article/details/80356192

版权

MySQL 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

创建一个zoom的数据库

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

可以看出创建成功

mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| zoom               |
+--------------------+
5 rows in set (0.00 sec)

查看创建信息

mysql> SHOW CREATE DATABASE zoom;
+----------+---------------------------------------------------------------+
| Database | Create Database                                               |
+----------+---------------------------------------------------------------+
| zoom     | CREATE DATABASE `zoom` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+---------------------------------------------------------------+
1 row in set (0.00 sec)

创建一个gbk（也可以其他编码）的数据库

mysql> CREATE DATABASE zoom_gbk CHARACTER SET gbk;
Query OK, 1 row affected (0.04 sec)

mysql> SHOW CREATE DATABASE zoom_gbk;
+----------+------------------------------------------------------------------+
| Database | Create Database                                                  |
+----------+------------------------------------------------------------------+
| zoom_gbk | CREATE DATABASE `zoom_gbk` /*!40100 DEFAULT CHARACTER SET gbk */ |
+----------+------------------------------------------------------------------+
1 row in set (0.00 sec)

修改数据库编码方式

mysql> ALTER DATABASE zoom_gbk CHARACTER SET utf8;
Query OK, 1 row affected (0.00 sec)

mysql> SHOW CREATE DATABASE zoom_gbk;
+----------+-------------------------------------------------------------------+
| Database | Create Database                                                   |
+----------+-------------------------------------------------------------------+
| zoom_gbk | CREATE DATABASE `zoom_gbk` /*!40100 DEFAULT CHARACTER SET utf8 */ |
+----------+-------------------------------------------------------------------+
1 row in set (0.00 sec)

删除数据库

mysql> DROP DATABASE zoom_gbk;
Query OK, 0 rows affected (0.01 sec)
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| zoom               |
+--------------------+
5 rows in set (0.00 sec)