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