I got 2 tables :
CREATE TABLE
p(id_p INT AUTO_INCREMENT PRIMARY KEY,
name_p VARCHAR(50),
surname_p VARCHAR(50)
UNIQUE (name_p,surname_p);
and
CREATE TABLE
t_int(name_int VARCHAR(40),
surname_int VARCHAR(40),
name_m VARCHAR(40),
surname_m VARCHAR(40),
cab VARCHAR(50));
I need to move name_int
and surname_int
into p table on name_p
and surname_p
.
My problem is this:
I can't make an unique index for the name_p
and surname_p
combination, and on insert I get duplicate error(there are 300k entries). Since I need all of them inserted what should I do?
Insert ignore is not a valid option for me since it is not going to insert them all.
I really need help. Thank you.
Aucun commentaire:
Enregistrer un commentaire