What I want to do is:
UPDATE table SET field = MAX(field) + 1 WHERE id IN (1, 3, 5, 6, 8);
The semantics of this statement, in my mind, would be first the database would go off and determine for me what the largest value of field is in all of table. It would then add 1 to that value, and assign the resulting value to the field column of the rows with id 1, 3, 5, 6, and 8. Seems simple enough...
When I try to run that query though, MySQL chokes on it and says:
ERROR 1111 (HY000): Invalid use of group function
What's the secret sauce you have to use to get the outcome I desire?
Regards, Vic