CREATE TEMPORARY TABLE tt SELECT * FROM your_table;
UPDATE tt SET your_index = NULL;
INSERT INTO your_table SELECT * FROM tt;
Tom Ray [Lists] wrote:
> Hey, I have a really simple question (I hope)..I have a database that
> has a field in it that autoindexes the number. I screwed up and
> imported a bunch of wrong data. Up to row 200 it's right, beyond that
> it was wrong so I had delete it all. The problem now is the
> autoindexing is set to 1105, I want to change it so the next insert
> gets a number of 201 not 1105.
> I've tried to change it via phpMyAdmin but it keeps going back to
> 1105. Is there anyway I can do this?