建库建表设置统一编码

1、

CREATE DATABASE `database_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

2、

creat table `table_name` (
    `id`  int(11)  unsigned primary key auto_increment;
    `name` varchar(10) not null comment "名字"
)engine=innodb charset=utf8 comment="举个栗子";