Tell me more ×  I'm trying to insert in the following table
ABC(user text, num int), Where user is primary key two tuples:
(aaa, 1) (aaa, 2)  What is the result of this?  share|improve
this question add comment  2 Answers  up vote 1 down vote
accepted  The first insert will work (if there is not already a
row with that primary key).  And the second insert will fail :
duplicate primary key.  share|improve this answer add comment
The second insert will fail as you already used that key in the
table.  share|improve this answer add comment  Your Answer