Hi Drizzlers, How does one do bulk updates in Drizzle? One can easily do bulk inserts via multi-row insert. One can do a single update to a lot of rows. But one can't do a lot of updates (in a single statement). Suppose I've got 10000 key value (int) pairs that need to be updated. How would you do it? In MySQL I've (ab)used insert ... on duplicate update, but that doesn't work anymore due to a safer SQL mode. I'd like to avoid using temporary tables.
See also https://bugs.launchpad.net/drizzle/+bug/691974 -- Olaf _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
