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 ...

The company, which operates an online community for moms, was running a 300GB MySQL data warehouse to analyze its user clickstream data. Performance was sluggish.

I've read the docs on the MySQL website and still can't get this to work. I have a huge text file I want to load and don't want to use "insert" for each line. That would be dumb.