Hi all. I have searched the documentation, and i found some info, but I wanted to ask
the lsit a little more about auto_increment.
First, if I use auto_increment, and then delete a field, I assume mysql leaves the
remaining fields with the original numbers...
i.e. if I haverows 1 through 10 and delete row 1, the other rows are still 2-9. Is
this correct. If I want to insert something with a value of 1, is that easy to do?
What if I decide to reorganize the rows. Must I drop them and repopulate, or can I
just shuffle them to the order I want?
Finally, do most of you findauto-increment to be pretty useful or more restrictive, or
both, useful but restrictive?
Thanks,
Taylor
Taylor Lewick
Unix System Administrator
Fortis Benefits
816 881 6073
"Help Wanted. Seeking Telepath..."
"You Know where to apply."
****************************************************************
Please Note
The information in this E-mail message is legally privileged
and confidential information intended only for the use of the
individual(s) named above. If you, the reader of this message,
are not the intended recipient, you are hereby notified that
you should not further disseminate, distribute, or forward this
E-mail message. If you have received this E-mail in error,
please notify the sender. Thank you
*****************************************************************
---------------------------------------------------------------------
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
