Does anyone know mysql handles duplicate key handling during multi inserts?

INSERT INTO test values(1,2),(3,4),(4,5),(1,6),(6,7);

Now the above statement fails and gives duplicate key error and exits.
Is there a way for it to ignore the key violation and continue
processing the batch?

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to