Andre Polykanine wrote:
It's not a strictly PHP question, however since I use that with PHP,
I'm asking it there.
How can I accomplish the task of inserting rows into MySql database
with missing IDs? Say, I have rows with IDs 1, 2, 3, 5, 9, 12, 17, and
195. How do I make the check that allows to insert firstly the missing
IDs and only then apply the auto-increment?
Almost certainly you should not want to.
The ID should simply be unique, and have no inherent meaning.
Why do you care if there are gaps?
But if you must, just select the IDs, put them in an array, and query
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php