update后不能直接跟limit条件;要先用select选出后,在用in条件进行update;
update table set field=‘内容’ where id in (select id from (select * from table where 条件 limit n,m) as a);
#sql#更新某个字段,后接where和limit条件
最新推荐文章于 2023-01-05 08:00:00 发布
update后不能直接跟limit条件;要先用select选出后,在用in条件进行update;
update table set field=‘内容’ where id in (select id from (select * from table where 条件 limit n,m) as a);