PHP Mysql Duplicate Entry Error for Unique Column -


i have ton of data have parse , insert mysql database.

some of duplicate, setup unique index on column needs unique.

instead of running insert queries 1 1, i'm doing batches of 100 lessen load on db. if duplicate entry error, seems entire batch not inserted. there way structure query "if there duplicates ignore please insert rest of data"?

thanks in advance.

you can use ignore keyword that: http://dev.mysql.com/doc/refman/5.5/en/insert.html


Comments

Post a Comment

Popular posts from this blog

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -

i'm using dynamic linq library , there source code , basic docu , nuget version pm> install-package dynamiclinq i'm trying construct clause involves guids i have tried string "id == @0" . parameter array object[] value ( guid xxxx ) var whereclausesb = buildlogicalkeywhereclause2(entity, logicalkey); //build string var parms = buildparamarray(entity, logicalkey); // object[] var wherelambda = ofsi.bos.core.dynamicexpression.parselambda<t, bool>(whereclausesb.tostring(),parms); //parse an exception thrown in dynamicexpression.parselambda operator '==' incompatible operand types 'guid' , 'guid' i have tried guid , string.(fail) i tried , "id = @0" (fail). string == string works, int32==int32 not guid == guid not any ideas? try using equals method instead of == operator in string: "id.equals(@0)"
Read more