Skip navigation links

MySQL Forums :: Newbie :: Change AutoIncrement Value


Advanced Search

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 Ramazan Pekin 08/21/2008 03:08AM
Re: Change AutoIncrement Value Jon Roshko 08/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.