[MYSQL]ON DUPLICATE KEY UPDATE

중복 발생시 카운트 올리기  

INSERT INTO log (name, location, counter)

    -> VALUES ('Tantor', 'Waterhole', 1)

    -> ON DUPLICATE KEY UPDATE counter=counter+1;

Query OK, 1 row affected (0.00 sec)

mysql> SELECT * FROM log;

+--------+-----------+---------+
| name   | location  | counter |
+--------+-----------+---------+
| Tantor | Waterhole |       1 |
+--------+-----------+---------+
1 row in set (0.00 sec)



mysql> INSERT INTO log (name, location, counter)

    -> VALUES ('Tantor', 'Waterhole', 1)

    -> ON DUPLICATE KEY UPDATE counter=counter+1;

Query OK, 2 rows affected (0.00 sec)