MySQL常用命令

MySQL创建数据库命令：CREATE DATABASE databasename CHARACTER SET [charater_set] COLLATE [collation]
例如：CREATE DATABASE test CHARACTER SET utf8 COLLATE utf8_general_ci

显示character set命令：show character set;

显示collation命令：show collation;