Change AutoIncrement Value
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.
Subject
Written By
Posted
Change AutoIncrement Value
August 21, 2008 03:08AM
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.