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