update t_notice
set addUser="李四"
where id in
(select id from (select * from t_notice ORDER BY RAND() LIMIT 3) as a);
mysql同一张表 查询出来的数据同时进行更新
最新推荐文章于 2024-07-05 02:15:39 发布
update t_notice
set addUser="李四"
where id in
(select id from (select * from t_notice ORDER BY RAND() LIMIT 3) as a);