[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