DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `proc_RealData`(IN `timeBegin` DATETIME, IN `timeEnd` DATETIME, IN `timeInterval` INT)
? ? MODIFIES SQL DATA
? ? SQL SECURITY INVOKER
? ? COMMENT '/*存儲過程：按起始、終止時間，以及時間間隔，抽取數(shù)據(jù)*/'
BEGIN
? ? ? ? SET @time := '1000-01-01 00:00:00';
? ? ? ? SET @interval := timeInterval;
? ? ? ? SELECT * FROM realdata_table
? ? ? ? WHERE `realdata_table`.`received_time` >= timeBegin AND `realdata_table`.`received_time` <= timeEnd
? ? ? ? AND TIMESTAMPDIFF( SECOND, @time, `realdata_table`.`received_time` ) >= @interval
? ? ? ? AND @time := `realdata_table`.`received_time`;
END$$
DELIMITER ;

SET @p0='2016-03-29 00:00:00';?
SET @p1='2016-03-31 00:00:00';?
SET @p2='3600';?
CALL `proc_RealData`(@p0, @p1, @p2);

CREATE DEFINER=`root`@`localhost` PROCEDURE `proc_RealData`(IN `timeBegin` DATETIME, IN `timeEnd` DATETIME, IN `timeInterval` INT)
    MODIFIES SQL DATA
    SQL SECURITY INVOKER
    COMMENT '/*存儲過程：按起始、終止時間，以及時間間隔，抽取數(shù)據(jù)*/'
BEGIN
        SET @time := '1000-01-01 00:00:00';
        SET @interval := timeInterval;
        SELECT * FROM em_air_humidity
        WHERE `em_air_humidity`.`DateTime` >= timeBegin AND `em_air_humidity`.`DateTime` <= timeEnd
        AND TIMESTAMPDIFF( SECOND, @time, `em_air_humidity`.`DateTime` ) >= @interval
        AND @time := `em_air_humidity`.`DateTime`;
END