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