sql 新增随机数

update RemoteDetection set humidity=round((rand()*3+29),0),TEMPERATURE=round((rand()*3+16),0),atmosphere=round((rand()*2+101),1),WINDSPEED=round((rand()*2+2),1)  where REMOTEDETECTIONID=‘2‘

原文：https://www.cnblogs.com/luoguixin/p/12004787.html