Backend with Golang

MySQL - on duplicate key를 할 때 update만 했는데 id가 증가하는 이유

아직개구리 2023. 7. 11. 17:56

https://stackoverflow.com/questions/23516958/on-duplicate-key-auto-increment-issue-mysql 

 

ON DUPLICATE KEY + AUTO INCREMENT issue mysql

I have table structure like this when I insert row to the table I'm using this query: INSERT INTO table_blah ( material_item, ... hidden ) VALUES ( data, ... data ) ON DUPLICATE KEY UPDATE id = id,

stackoverflow.com