人生苦短，我学python

SELECT DATE_FORMAT(SYSDATE(),’%Y-%m-%d %H:%i:%s’);

BEGIN/*定义变量*/DECLARE time TIMESTAMP;DECLARE building SMALLINT;DECLARE floor SMALLINT;DECLARE room SMALLINT;DECLARE data_type SMALLINT;DECLARE data_value SMALLINT;DECLARE device_id SMALLINT;/*定义循环标志，默认为false*/DECLARE done INT DEFAULT FALSE;/*定义