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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]