I want to add records to the table but there is a duplicate

Question

I have a table named Car and I want to add this records;

insert into Car 
values 
 ('a', 'a'), ('a', 'b'), ('a', 'c'),('b', 'b'), ('b', 'c'), ('c', 'd'), ('d', 'd');

I got this massage: ( ERROR 1062 (23000): Duplicate entry 'a' for key a)

so how I can fix it?

Adhere to the table structure, if the column is any key then you cannot insert duplicate to that column — Dinesh Guptha, Oct 14 '20 at 02:37
Does this answer your question? [Error: Duplicate entry '' for key 'email'](https://stackoverflow.com/questions/33673946/error-duplicate-entry-for-key-email) — hestellezg, Oct 14 '20 at 05:41

user9601310 · Accepted Answer · 2020-10-14T04:45:43.417

0

You have defined either a Primary Key or a Unique Key on the first column of the Car table. Either redefine the table without the Primary Key or Drop the Index. See demo here.
Another possibility is that you intended the unique key to be a composite of the two fields, in which case you need to amend your CREATE UNIQUE INDEX, as also shown in the demo.

edited Oct 14 '20 at 04:45

answered Oct 14 '20 at 04:39

user9601310

1,076
1
7
12

I want to add records to the table but there is a duplicate

1 Answers1