需求:给水质表 ph字段生成随机数:7.4-8.1
update ecoi_hydrology set ph = CAST(RAND() * (8.1 - 7.4) + 7.4 AS DECIMAL) WHERE ph is NULL;
需求:给水质表 ph字段生成随机数:7.4-8.1
update ecoi_hydrology set ph = CAST(RAND() * (8.1 - 7.4) + 7.4 AS DECIMAL) WHERE ph is NULL;