mysql同一张表 查询出来的数据同时进行更新

update t_notice
set addUser="李四"
where id in
(select id from (select * from t_notice ORDER BY RAND() LIMIT 3) as a);

展开阅读全文

没有更多推荐了,返回首页