Hi,
I need to update a table along the lines of the following
update table set LastUpdate=now(), UpdateSource='Abc' Where Key1 = 'Def'
and Key2 = 'ghi'
I need to possible do anywhere from 2 to 20 of these. Would it be better
to call an update statement for each of these,
or should I do a batch INSERT with ON DUPLICATE KEY UPDATE?
Going to try both ways now, but was wondering what would be the best
"internally" my instincts tell me the latter.
Thanks,
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
