MySQL Forums
Forum List  »  Newbie

Change AutoIncrement Value
Posted by: Ramazan Pekin
Date: August 21, 2008 03:08AM

Hi,

I have a table and there is an id column with this datas:

1
2
3
4

9001
9002
.
.
.

It was not auto incremental column and after change this column as auto_increment, the new records' ids started from 9002+. But I want to change it and give new ids started from 5.

SHOW TABLE STATUS LIKE 'mytable' -> giving to me next auto increment value. How can I set this value to 5?

After a lot of time, maybe never, this auto increment value will be setted as 9002+.

Thanks for your helps.

Options: ReplyQuote


Subject
Written By
Posted
Change AutoIncrement Value
August 21, 2008 03:08AM
August 21, 2008 02:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.