Iulian Glăvan Iulian Glăvan - 26 days ago 17
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

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.

Comments