| 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 handling | Mir Islam | 4 Sep |
| • Re: multi inserts and duplicate key handling | Paul DuBois | 4 Sep |
| • Re: multi inserts and duplicate key handling | Eric Bergen | 4 Sep |
