[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)