[Wolves] Bulk updates to MySQL databases

DragonMaster LUG at clews.homelinux.net
Mon Sep 14 13:06:20 UTC 2009


Does anyone know if it is possible to perform bulk updates on an insert
similar to the following:

INSERT IGNORE INTO <table> (<field1>, <field2>) VALUES (<Value1>,
<Value2>), (<Value1>, <Value2>) ON DUPLICATE KEY UPDATE <Field1> =
(<Value1>, <Value2>), <Field2> = (<Value1>, <Value2>);

I have got the query to work right up to the multiple updates on the
duplicate key condition, but cannot pursuade the database to update
multiple entries...

Regards,

DM





More information about the Wolves mailing list