1 /etc/init.d/mysql start
 2 
 3 mysql>create database record character set ‘utf8‘ collate ‘urf8_general_ci‘;
 4 
 5 mysql>use record 
 6 
 7 mysql>create table sum_vacation (data date,score int,dis1 varchar(20),dis1 varchar(20),dis3 varchar(20)) engine=innodb default charset=utf8
 8 
 9  mysql>show variables like ‘character_set_%‘
10 
11 mysql>show databases update sum_vacation set scroe=‘2‘ where data=‘20140801‘;
12 
13 mysql> update sum_vacation set scroe=‘2‘ where data=‘20140801‘;
14 Query OK, 1 row affected (0.01 sec)
15 Rows matched: 1  Changed: 1  Warnings: 0