MannX
-
Posts
1 -
Joined
-
Last visited
Never
Everything posted by MannX
-
how do I reset the index (usernumber) that is autoincrement
MannX replied to eastcoastdubs's topic in MySQL Help
Hi, 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 ? MannX.. :roll: