创建库
create database secondweek;
查看库
show databases;
查看某库具体信息
show create database secondweek;
显示secondweek的编码方式为latin1;
查看库有几个表
use firstweek;
show tables ;
选择数据库
use secondweek;
修改库
修改库名
mysql 没有类似rename database 命令，只能变相修改表到目标库来实现;
修改编码方式
将secondweek的编码方式latin1修改成utf8;
alter database secondweek character set utf8 collate utf8_bin;
删除库
drop database secondeweek;