MySQL随机产生经纬度

UPDATE `stkj_cloud_iot`.`stkj_device` SET `lng_default` = (SELECT (RAND() * (105.33284067689894 - 105.43284067689894)) + 105.33284067689894 ) ;
UPDATE `stkj_cloud_iot`.`stkj_device` SET `lng_current` = (SELECT (RAND() * (105.33284067689894 - 105.43284067689894)) + 105.33284067689894 ) ;
UPDATE `stkj_cloud_iot`.`stkj_device` SET `lat_default` = (SELECT (RAND() * (30.10216132869794 -30.11216132869794)) + 30.10216132869794 ) ;
UPDATE `stkj_cloud_iot`.`stkj_device` SET `lat_current` = (SELECT (RAND() * (30.10216132869794 -30.11216132869794)) + 30.10216132869794 ) ;