Change AutoIncrement Value
Posted by: Ramazan Pekin
Date: August 21, 2008 03:08AM
I have a table and there is an id column with this datas:
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.
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.