创建一个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)转载于:https://www.cnblogs.com/toly-top/p/9782030.html
