This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery’ 解决办法:在外面嵌套一层
update receivesheetconfirm set Status=3 where ReceiveSheetNo in (select ReceiveSheetNo from (select ReceiveSheetNo from receivesheetconfirm limit 0,60) tt)`
This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery’ 解决办法:在外面嵌套一层
update receivesheetconfirm set Status=3 where ReceiveSheetNo in (select ReceiveSheetNo from (select ReceiveSheetNo from receivesheetconfirm limit 0,60) tt)`