1.创建
CREATE DATABASE/SCHEMA db_name;
CREATE DATABASE/SCHEMA IF NOT EXISTS db_name DEFAULT CHARACTER SET charset_name DEFAULT COLLATE collation_name;//设置数据的默认字符集和校对规则
e.g:
CREATE DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;//utf8
REATE DATABASE db_name DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci; //gbk
2.修改
ALTER DATABASE/SCHEMA db_name DEFAULT CHARACTER SET charset_name DEFAULT COLLATE collation_name;
3.删除
DROP DATABASE/SCHEMA IF EXISTS db_name;
4.载入(使用数据库)
mysql -uroot -p进入mysql命令行:
use db