List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 4 2004 12:23am
Subject:Re: multi inserts and duplicate key handling
View as plain text  
At 17:03 -0700 9/3/04, Mir Islam wrote:
>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?

INSERT IGNORE INTO ...

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Thread
multi inserts and duplicate key handlingMir Islam4 Sep
  • Re: multi inserts and duplicate key handlingPaul DuBois4 Sep
Re: multi inserts and duplicate key handlingEric Bergen4 Sep