mysql命令

mysql创建数据库带指定编码：
CREATE DATABASE IF NOT EXISTS inventory DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
create database inventory  DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
create database inventory  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;