Inserting rows with missing IDs
| From: | Andre Polykanine | Date: | Mon, 03 May 2010 13:34:10 +0000 |
| Subject: | Inserting rows with missing IDs | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-304876@lists.php.net to get a copy of this message | ||
Hello everyone,
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?
Thanks!
--
With best regards from Ukraine,
Andre
Http://oire.org/ - The Fantasy blogs of Oire
Skype: Francophile; Wlm&MSN: arthaelon @ yandex.ru; Jabber: arthaelon @ jabber.org
Yahoo! messenger: andre.polykanine; ICQ: 191749952
Twitter: http://twitter.com/m_elensule