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

Because MySQL is such a popular database, I thought it would be a great data source to use as an illustration. This will also refresh your memory on how to set MySQL up for remote connections.

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.