I had a table as below
CREATE TABLE test (
id character varying(300) ,
name character varying(400)
);
ALTER TABLE test ADD PRIMARY KEY (Id);
I had the following insert statements
insert into test(id,name)values('1','ram')`;
insert into test(id,name)values('1','sam')`;
In the above insert statements i am trying to insert duplicate ‘id’. I am getting the error saying duplicate value the value already exits.
Is their any other way that we can declare a column as primary key and duplicate the primary key