Error 1062. Duplicate entry in mysql -
i have mysql table schema in column 1 primary key. have tsv file need insert in table. now, tsv has repetition of primary key hence when try insert in mysql table gives error
error 1062 (23000): duplicate entry '107664521128181760' key 'primary'
is there way if primary key value exists, should ignore , move further next insertion.
you looking insert ignore into command.
you can try this:
insert ignore yourtablename(col1,col2...) values(val1,val2,...)