I have a MySQL table whose schema in which column 1 is primary key.
I have a tsv file which I need to insert in this table. Now, the tsv has repetition of primary key hence when I try to insert it in MySQL table it gives an error
ERROR 1062 (23000): Duplicate entry '107664521128181760' for key
'PRIMARY'
Is there any way by which if the primary key value already exists, then it should ignore and move further for next insertion.
解决方案
It depends on how you are importing the data.
If you are using LOAD DATA INFILE command then use IGNORE in command as:
LOAD DATA INFILE 'member.tsv'
IGNORE INTO TABLE tbl_member
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
(name, age);
And if you are using sql having INSERT command then use INSERT IGNORE in INSERT command as:
INSERT IGNORE INTO yourtablename(col1,col2...)
values(val1,val2,...)