hi,
I have a mysql table with a field:
Field name     Type    Allow nulls?    Key            Extras
NR                 int(11)    No                Primary     auto_increment

In table i have values for NR field: 1,2,3...50 and 888888.
I del that line with 888888, but when i try to add a record, NR is
automatically assigned with 888889.
I want that value 51, but somewhere MySQL has recorded the big value.
 How to restart  increment counter to start with 51?
tx



---------------------------------------------------------------------
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

Reply via email to