MYSQL 创建数据库

<pre name="code" class="sql"><pre name="code" class="sql">如下脚本创建数据库yourdbname，并制定默认的字符集是utf8。CREATE DATABASE IF NOT EXISTS zjzb  DEFAULT CHARSET utf8 COLLATE utf8_general_ci;如果要创建默认gbk字符集的数据库可以用下面的sql:create database yourdb DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;mysql> CREATE DATABASE IF NOT EXISTS zjzb  DEFAULT CHARSET utf8 COLLATE utf8_general_ci;Query OK, 1 row affected (0.02 sec)mysql> show create database  zjzb;+----------+---------------------------------------------------------------+| Database | Create Database                                               |+----------+---------------------------------------------------------------+| zjzb     | CREATE DATABASE `zjzb` /*!40100 DEFAULT CHARACTER SET utf8 */ |+----------+---------------------------------------------------------------+1 row in set (0.00 sec)[mysql@master data]$ ls -ltr | grep ^d | awk '{print $NF}'  | while read A> do> du -sh $A> done636Kperformance_schema1.6Mmysql8.0Ka108.0Ka208.0Ka308.0Ka50116Ka40240Kplmsdb9.1Mnba1.8Gtest8.0Kzjzb[mysql@master data]$ cd test[mysql@master test]$ lsdb.opt  students.frm  students.ibd  t1.frm  t1.ibd  t10.frm  t10.ibd  t2.MYD  t2.MYI  t2.frm  t3.frm  t3.ibd  t4.MYD  t4.MYI  t4.frm  t5.MYD  t5.MYI  t5.frm  t6.frm  t6.ibd  unload.sh什么是校对集？校对集：指字符集的排序规则。查看所有校对集语句：show collation;一种字符集可以有一个或多个排序规则。以utf8为例，默认是使用utf8_general_ci校对集