In BEFORE INSERT TRIGGER, is there any method to terminate the insert
other than raise an error and SIGNAL SQLSTATE?
The requirement is to insert a batch of records, if the record is
duplicated then cancel the insert and go on with the next record. The
only method i can find is to cancel the insert by SIGNAL SQLSTATE, but
it will terminate the whole batch of records, which is not correct.