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,...) 

Popular posts from this blog