auto_increment and the primary key
Posted: Sun Jul 28, 2002 7:15 pm
i wanted to know if there is anyway i can reset the autoindex.
see what happened is that i wanted to check to see if my member list worked..(and it did), so i had to add a whole bunch of users.. when i was doen i delted them all...
but i have an autoindex thing that still stays at the 24 mark(well it says thats the next) and even though i have one row and its id is 1...
heres what it says on myphpadmin
see what happened is that i wanted to check to see if my member list worked..(and it did), so i had to add a whole bunch of users.. when i was doen i delted them all...
but i have an autoindex thing that still stays at the 24 mark(well it says thats the next) and even though i have one row and its id is 1...
heres what it says on myphpadmin
Code: Select all
Indexes:
Keyname Type Cardinality Action Field
PRIMARY PRIMARY 1 Drop Edit id
Row Statistic:
Statements Value
Format dynamic
Rows 1
Row length ø 232
Row size ø 2,280 Bytes
Next Autoindex 24