On Tue, May 3, 2011 at 12:52 AM, Brian Aker <[email protected]> wrote: > Provide an example in SQL?
This is what I use now, but it fails with strict mode enabled because it mixes inserts and updates while I want updates-only. Obviously the number of rows is much larger in the real case. insert into xbt_files (fid, leechers, seeders, completed) values (2,6268,4510,38453) on duplicate key update leechers = values(leechers), seeders = values(seeders), completed = values(completed); https://bugs.launchpad.net/drizzle/+bug/691974 _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
