phpMyAdmin picking up strange value from somewhere

[crmamx]

Using phpMyAdmin I loaded 6 test records with the id set to auto_increment and it loaded all the data correctly with id # 1-6.

 

Then from somewhere it got the number 333353  and auto_increments it as the value for the id. So now I have id's 1-6 and 333353, 333354, ect. For every record I add it increments it.

 

I deleted all but records 1-6 and tried again but it has the last value of 3333xx stored somewhere and increments it. Deleted them again, closed the program, came back and it still does it.

[denno020]

Try exporting the sql for the problem table and then create a new one. See if that helps.

[QuickOldCar]

ALTER TABLE table_name AUTO_INCREMENT = 7;

[crmamx]

Bingo!

 

That's some deep stuff. My hosts phpMyAdmin could not fix it.

 

I had two old fast cars, 68 and 69 AMX. Wish the hell I had kept them.

 

Thanks a jillion.