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