Iulian Glăvan Iulian Glăvan - 1 year ago 87
MySQL Question

load data infile

I don't know how to fix that warrning.

enter image description here

I try with Ignore, but in vain.

create table MEDICI ( id_m int auto_increment primary key,
nume varchar(100) unique,
prenume varchar(100) unique,
statut enum('Primar','Specialist'),
specialitate varchar(50)
);

Answer Source

While loading the data to the table, there are two same values Nutu exist for column prenume. Column prenume is defined as unique.

Correct the data and try loading the data into table.