On Sun, 15 Dec 2002 17:38:49 -0600, Paul DuBois wrote:
>>>INSERT INTO gebaeude_daten VALUES (0, 'Bank Stufe 1', 1000, 30, 900, 1);
What happens if you use a value of NULL instead of 0?
Inserting a field with 0 tells the table to generate a value on its
own, like it's supposed to.
From your post you appear to be trying to assign a value to the
auto_increment which defeats its purpose. I would suggest tracking the
"current ID" for this table in another table, then inserting it
yourself. Remember to lock the second table to prevent two sessions
from using the same number.
>>>Every time I change the table definition with ALTER, the 0 becomes the next
>>>auto-index.
The user comments on this page point out that setting a value
for an auto-increment field with ALTER TABLE will reset the counter to
the provided value.
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
- Steve Yates
- Does "Microsoft" mean small and limp?
~ Taglines by Taglinator - www.srtware.com ~
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
