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
