项目中需要将以此搜索出来的10条语句的推送状态全部改变,于是写了如下SQL语句:
"update pdf_generate_records set push_state = 1 where id in (select a.id from pdf_generate_records where generate_result=0 and push_state=0 limit 10"。
结果控制台报错“This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery”。
解决方法:
将SQL语句改为如下:
"update pdf_generate_records set push_state = 1 where id in (select a.id from (select id from pdf_generate_records where generate_result=0 and push_state=0 limit 10) as a)"。
成功更新数据。