mysql> create table t_test ( i int primary key auto_increment , j int , k int ) ;query ok, 0 rows affected (0.15 sec) mysql> mysql> mysql> insert into t_test values(1,1,1) on duplicate key update j = j+1 , k=k+1 ;query ok, 1 row affected (0.21 sec)mysql> mysql> insert into t_test values(1,1,1) on duplicate key update j = j+1 , k=k+1 ;query ok, 2 rows affected (0.04 sec)mysql> select * from t_test ;+---+------+------+| i | j | k |+---+------+------+| 1 | 2 | 2 |+---+------+------+1 row in set (0.00 sec)mysql> insert into t_test values(1,1,1) on duplicate key update j = j+1 , k=k+1 ;query ok, 2 rows affected (0.00 sec)mysql> select * from t_test ;+---+------+------+| i | j | k |+---+------+------+| 1 | 3 | 3 |+---+------+------+1 row in set (0.00 sec)
建立连接的时候指定 useunicode=true characterencoding=utf-8 参数可防止乱码