how do I reset the index (usernumber) that is autoincrement
Posted 14 February 2003 - 01:23 AM
Since I am in the test phase I put random info in and everything works fine. My problem is that when I delete a record ( up to 17 so far from testing ) The autoincremented number keeps going from 17 to 18 and so on. How do I reset the indexes so it starts at 1 again?
Posted 16 February 2003 - 10:25 PM
Maybe eastcoastdubs also needs to know how to make use of the blanked out record IDs.
Say for instance, if there is a table with 10 record rows and indexed between 1 to 10 . Then the whole record on index 5 row is deleted by DELETE FROM table_name WHERE id=\'5\'. Thus leaving the index 5 unused....
How to reuse this index 5? Anyone ?
Posted 25 February 2003 - 01:35 AM
I\'m gonna jump in here, hope someone can help us out.
Posted 01 March 2003 - 12:49 AM
<?php str_replace("ASP", "PHP", $str); ?>
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users