MySQL Commons_MySQL

mysqldump Usage: mysqldump [OPTIONS] database [tables]OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]OR     mysqldump [OPTIONS] --all-databases [OPTIONS]

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 参数可防止乱码