List:General Discussion« Previous MessageNext Message »
From:Mir Islam Date:September 4 2004 12:03am
Subject:multi inserts and duplicate key handling
View as plain text  
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?
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