Sometimes we need to add a column that we require into the table. we can do this by using add keyword with alter command.syntax:to add a column into a table, use the following syntax:alter table table ...

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