You can set where auto-increment starts. I believe it works in MySQL 4.1; I don't see why it wouldn't (but I hope you have a really good reason for sticking to 4.1).<BR><BR>ALTER TABLE tablename ...

Sure!<P>Based on the way database servers "do their stuff" there is absolutely no way to guarantee the order in which a SELECT returns tuples (results). What you want to do is add a column that ...