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'

posted @ 2019-12-08 10:38  不再犯错  阅读(385)  评论(0编辑  收藏  举报