Ignore mysql error while executing bulk statements
Sometimes when running MySQL in batch mode, it requires to ignore some mysql errors which pops in between.
As an example, we can consider a scenerio where thousands of inserts required to be done and the statements are saved in a file, suppose in indata.sql. But it may be the case that some records are already there in database which you’re trying to insert. MySQL will show error something like below and exit:
ERROR 1062 (23000) at line 6: Duplicate entry 'blablabla' for key 2