Re: table with multiple primary key
It's a composite primary key. A multiple primary key isn't possible.
Your Create Table statement already created the composite PK(id,date), so you can't add date to that key.
Doing this with Alter Table would be awkward, since auto_increment is allowed only in a PK. So do it as a one-step in the Create Table statement.
Subject
Written By
Posted
September 01, 2014 11:03PM
Re: table with multiple primary key
September 01, 2014 11:23PM
September 02, 2014 12:27AM
September 02, 2014 10:10AM
September 02, 2014 07:14PM
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.