On Wed, Apr 6, 2011 at 2:24 PM, Olaf van der Spek <[email protected]> wrote: > 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
Somebody? -- 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
