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
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
mysql select * from t;
+---+
| t |
+---+
| 1 |
| 2 |
| 3 |
+---+
3 rows in set (0.00 sec)
-Eric
On Fri, 3 Sep 2004 19:23:03 -0500, Paul DuBois [EMAIL PROTECTED] wrote:
At 17:03 -0700 9/3/04, Mir Islam wrote:
Does anyone know mysql handles duplicate key handling during multi inserts?
INSERT