I am currently having problems with a primary key ID which is set to auto increment. It keeps incrementing ON DUPLICATE KEY. For Example: From the description above, you’ll notice that I have 3 inputs in that table but due to auto increment on each update, ID has 86 for the third input. Is there anyway to avoid this ?