Create databases < database name >
Mysql> Show CREATE Database oldboy\g
1. Row ***************************
Database:oldboy
Create database:create Database ' Oldboy '/*!40100 DEFAULT CHARACTER SET UTF8 */
1 row in Set (0.00 sec)
Establish a GBK character set database named OLDBOY_GBK
Mysql> CREATE DATABASE Oldgirl CHARACTER SET GBK COLLATE gbk_chinese_ci;
Query OK, 1 row Affected (0.00 sec)
Mysql> Show CREATE Database oldgirl\g
1. Row ***************************
Database:oldgirl
Create database:create Database ' oldgirl '/*!40100 DEFAULT CHARACTER SET GBK */
View character set and proofing rules: show character set; Create database commands in different character set formats
Create Database Oldboy; <== The default database configuration, which is equivalent to creating a Latin character Set database.
Create DATABASE OLDBOY_GBK DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci; #<== creating the GBK character Set database
Create DATABASE Oldboy_utf8 DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci; <== creating the UTF8 character Set database
MYSQL---Build character Set database