Hi Tom
CREATE TEMPORARY TABLE tt SELECT * FROM your_table;
TRUNCATE your_table;
UPDATE tt SET your_index = NULL;
INSERT INTO your_table SELECT * FROM tt;
suomi
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?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
