mysql5.5插入语句_MySQL 5.5 INSERT ... ON DUPLICATE KEY UPDATE语句说明

执行INSERT ... ON DUPLICATE KEY UPDATE语句，如果INSERT的语句插入的值和已有的UNIQUE索引或主键重复的话，MySQL会更新已存在的行。

测试没有主键和UNIQUE索引的表

mysql> select * from dept2;

+--------+-------------+-------------+

| deptno | dname       | report_date |

+--------+-------------+-------------+

|     10 | Research    | 2016-06-03  |

|     20 | Maintenance | 2016-06-03  |

|     30 | Leader      | 2016-06-03  |

|     40 | Market      | 2015-08-02  |

+--------+-------------+-------------+

4 rows in set (0.00 sec)

mysql> desc dept2;

+-------------+-------------+------+-----+---------+-------+

| Field       | Type        | Null | Key | Default | Extra |

+-------------+-------------+------+-----+---------+-------+

| deptno      | int(5)