Skip error while bulk inserting.

Question

I am using following query to bulk insert from one table to another.

INSERT INTO billitems SELECT * FROM billitems_old;

I want that if insert fails on any row, it must skip that row and proceed. Is there anything that I can include in the above query to skip errors.

Answer 1

insert ignore into billitems select * from billitems_old;

reference: insert

Answer 2

From the online documentation:

If you use the IGNORE keyword, errors that occur while executing the INSERT statement are treated as warnings instead.

So try:

INSERT IGNORE INTO billitems SELECT * FROM billitems_old