BEGIN
DECLARE set_time INT;
DECLARE mark_key VARCHAR(25);
DECLARE order_time VARCHAR(25);
DECLARE state VARCHAR(25);
DECLARE order_id_list int;
SELECT time INTO set_time from bao_set_time where id = 1;
DECLARE order_cursor2 CURSOR FOR SELECT order_id as order_id_list
from bao_order_home WHERE create_time < (unix_timestamp(now()) - set_time*3600) AND pay_state = 10;
DECLARE CONTINUE HANDLER FOR SQLSTATE "02000" SET order_id_list = '';
SET @@autocommit = 0;
START TRANSACTION;
OPEN order_cursor2;
FETCH order_cursor2 INTO order_id_list;
WHILE (order_id_list != '') DO
DELETE from bao_order_home WHERE order_id = order_id_list;
FETCH order_cursor2 INTO order_id_list;
END WHILE;
COMMIT;
SET @@autocommit = 1;
END
DECLARE set_time INT;
DECLARE mark_key VARCHAR(25);
DECLARE order_time VARCHAR(25);
DECLARE state VARCHAR(25);
DECLARE order_id_list int;
SELECT time INTO set_time from bao_set_time where id = 1;
DECLARE order_cursor2 CURSOR FOR SELECT order_id as order_id_list
from bao_order_home WHERE create_time < (unix_timestamp(now()) - set_time*3600) AND pay_state = 10;
DECLARE CONTINUE HANDLER FOR SQLSTATE "02000" SET order_id_list = '';
SET @@autocommit = 0;
START TRANSACTION;
OPEN order_cursor2;
FETCH order_cursor2 INTO order_id_list;
WHILE (order_id_list != '') DO
DELETE from bao_order_home WHERE order_id = order_id_list;
FETCH order_cursor2 INTO order_id_list;
END WHILE;
COMMIT;
SET @@autocommit = 1;
END