Tag: auto-increment

Prevent InnoDB auto increment ON DUPLICATE KEY

auto-increment mysql on-duplicate-key php

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 ?

PHP PDO Firebird inserting

auto-increment firebird insert pdo php

I’m new in Firebird but I’d like to write a small script in PHP that reads a CSV file and fills an existing Firebird db with its data. The problem is I don’t really know how to use the autoincrement …