增加
create database db1 charset=utf8;
--在别的电脑上运行文件时,可能不像自己电脑在本地配置了字符编码,转而使用默认编码
删除
drop database db2;
改动
alter database db2 charset=utf8; --改变数据库的字符编码
查询
show databases;
show create database db1; --查询创建数据库的语句
例:terminal
mysql> show create database dbforstudy;
+------------+-----------------------------------------------------------------------------------------------------------+
| Database | Create Database |
+------------+-----------------------------------------------------------------------------------------------------------+
| dbforstudy | CREATE DATABASE `dbforstudy` /*!40100 DEFAULT CHARACTER SET utf8mb3 */ /*!80016 DEFAULT ENCRYPTION='N' */ |
+------------+-----------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)