Insert explicit value on auto_increment field
I have defined a table with a field called ID that is auto_increment, and that is the primary key of the table. Currently the table has 30 records, whose ID values range from 1 to 30.
Now I need a record with ID = 0.
I tried:
INSERT INTO MyTable (ID, Name) VALUES (0,'something');
but it keeps inserting ID = 31.
How can I insert the record ID = 0 ?
Thanks
Subject
Written By
Posted
Insert explicit value on auto_increment field
May 17, 2018 07:29AM
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.