定时事件:
DELIMITER $$
ALTER DEFINER=`root`@`%` EVENT `NewEvent` ON SCHEDULE EVERY 30 SECOND STARTS '2018-10-08 14:00:00' ON COMPLETION NOT PRESERVE ENABLE DO CALL update_a()$$
DELIMITER ;
储存过程随机数:
DELIMITER $$
USE `figure`$$
DROP PROCEDURE IF EXISTS `update_a`$$
CREATE DEFINER=`root`@`%` PROCEDURE `update_a`()
UPDATE
fs_weather SET
temperature = ROUND (3.0 + (RAND() * 1.0),1),
humidity =ROUND (75.0 + (RAND() * 1.0),1),
noise =ROUND(25.0 + (RAND() * 45.0),1),
pm = ROUND(8.0 + (RAND() * 5.0),1),
wind_speed = CONCAT('东南风;',ROUND(2.0 + (RAND() * 1.0),1)),
oxygen = FLOOR(35200 + (RAND() * 400)),
pressure = ROUND(86.0 + (RAND() * 1.0),1),
rainfall = ROUND(0.5 + (RAND() * 0.5),1)
WHERE
id = '1'$$
DELIMITER ;
表:
CREATE TABLE `fs_weather` (
`id` bigint(20) NOT NULL,
`company_id` bigint(20) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
`created_by` bigint(20) DEFAULT NULL,
`last_modified_by` bigint(20) DEFAULT NULL,
`last_modified_date` datetime DEFAULT NULL,
`version` bigint(20) DEFAULT NULL,
`advice` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`air_duty_ratio` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`air_quality` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`average_temperature` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`high_temperature_trend` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`humidity` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`illumination` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`minimum_temperature_trend` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`noise` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`oxygen` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`pm` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`pressure` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`rainfall` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`temperature` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`weather_condition` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`wind_speed` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`air_quality_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`humidity_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`illumination_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`noise_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`pmtype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`pressure_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`rainfall_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`temperature_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`wind_speed_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci