Re: multi inserts and duplicate key handling

[Paul DuBois]

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