Error 1062. Duplicate entry in mysql

Question

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.

Answer 1

You are probably looking for INSERT IGNORE INTO command.

You can try like this:

INSERT IGNORE INTO yourtablename(col1,col2...)
values(val1,val2,...)