MySQL syntax for UPDATE + CASE WHEN + EXISTS + SELECT MAX

MySQL syntax for UPDATE + CASE WHEN + EXISTS + SELECT MAX

瀏覽:364
日期:2025-06-16
I am not 100% sure this does what you want, but I think it does: UPDATE tasks SET `Order`= coalesce((SELECT MAX(t.`Order`) + 1 AS `Order` FROM ......看更多