尝试
UPDATe TABLE set field = ((SELECT selected_value FROM (SELECt MAX(field) AS selected_value FROM table) AS sub_selected_value) + 1) WHERe id in (1,3,5,6,8)
尝试
UPDATe TABLE set field = ((SELECT selected_value FROM (SELECt MAX(field) AS selected_value FROM table) AS sub_selected_value) + 1) WHERe id in (1,3,5,6,8)
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
