# INSERT INTO ... SELECT ... ON DUPLICATE KEY UPDATE

**URL:** <https://forums.percona.com/t/insert-into-select-on-duplicate-key-update/784>\
**Category:** Other MySQL® Questions\
**Created:** [May 30, 2008, 6:38am UTC](https://forums.percona.com/t/insert-into-select-on-duplicate-key-update/784 "2008-05-30T06:38:06Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Emul](https://avatars.discourse-cdn.com/v4/letter/e/cdc98d/32.png) [@Emul](https://forums.percona.com/u/Emul)\
**Post date:** [May 30, 2008, 6:38am UTC](https://forums.percona.com/t/insert-into-select-on-duplicate-key-update/784/1 "2008-05-30T06:38:06Z")

</div>

Hi.

I want to archive a table contains search strings and results.  
I just want to sum the data like this:

INSERT INTO video\_search\_query\_log\_archive (query\_string, query\_string\_count, result\_count\_sum)(SELECT query\_string, COUNT(query\_string) AS qsc, SUM(result\_count) AS rcFROM video\_search\_query\_logGROUP BY query\_string)ON DUPLICATE KEY UPDATE query\_string\_count = qsc, result\_count\_sum = rc

Bu its not working, anyone can tell me how to make it work?!