update user set refid=10086 where uid in (select b from (select uid as b from user ORDER BY uid DESC LIMIT 1)as b)
我想更新refid字段 条件是 最新的一个uid 我这样写 查询时间居然要7秒多 才更新一条
请大神帮我看看还有没有其他快一点的语句
...全文
7794打赏收藏
mysql update where uid in 太慢了 有其他办法吗
update user set refid=10086 where uid in (select b from (select uid as b from user ORDER BY uid DESC LIMIT 1)as b) 我想更新refid字段 条件是 最新的一个uid 我这样写 查询时间居然要7秒多 才更新一条 请大神帮我看看还有没有其他快一点的语句