Mysql auto increment help

I have table with fields like id,title,no,url.

I want to auto increment id field

the table already has 1000 records in it with already some assigned ids

Now i want to auto increament the records that are newly inserted only .开发者_运维百科i do not want to auto increment the already present 1000 records .

Is there way i can do this???

---

ALTER TABLE tablename MODIFY id integer (11) auto_increment;

---

Just set column to autoincrement. It will increment only new ids, and will set the autoincrement to max(id) + 1. Even when the column is autoincrement, you can set a value, and you'll change the autoincrement counter.

Please note, you have to create index on id, in order to make it an auto-increment field.

---

yeah, just add auto increment to the field that has the ids already. The ids must be unique. The next auto_increment will be on the highest id present in the table....Try to use phpmyadmin

---

Check the largest value of the id

SELECT MAX (ID) FROM TABLE

and make the starting index for this table from the next value (+1)