关于 update不能用limit的问题
update userlist set `djid` = '1' where mid in (select a.mid from (select mid from userlist where name='xxx' limit 0,1 ) a)
用子语句就行了。
关于 update不能用limit的问题
update userlist set `djid` = '1' where mid in (select a.mid from (select mid from userlist where name='xxx' limit 0,1 ) a)
用子语句就行了。