SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;

存储过程写法：
label:BEGIN
DECLARE uid_orderid VARCHAR(255);
DECLARE userid int;
DECLARE uid_price FLOAT;
DECLARE leader_uid INT;
DECLARE extcredits INT;
DECLARE num INT;
SELECT 'run';
#SELECT orderid FROM pre_aljbd_goods_order where fl_status=0 and status=4 limit 1;
SELECT o.orderid,o.uid,o.price into uid_orderid,userid,uid_price FROM pre_aljbd_goods_order o where fl_status=0 and status=4 limit 1;
IF userid IS NULL THEN
LEAVE label;
END IF;
SELECT first_leader_uid INTO leader_uid FROM pre_aljsfx_user where uid=userid;
SELECT extcredits1 into extcredits FROM pre_common_member_count where uid=leader_uid;
set extcredits = extcredits-(uid_price*2.5);
set num=20;
WHILE extcredits <= 0 and num >0 DO
SELECT first_leader_uid INTO leader_uid FROM pre_aljsfx_user where uid=leader_uid;
set num = num - 1;
SELECT extcredits1 into extcredits FROM pre_common_member_count where uid=leader_uid;
INSERT INTO pre_adjfx_fl (uid, order_id, fl_value) VALUES ('1', '1', '1');
END WHILE;

UPDATE pre_common_member_count SET extcredits1= extcredits1 - (uid_price2.5), extcredits2= extcredits2+(uid_price2.5) WHERE (uid=leader_uid);

UPDATE pre_aljbd_goods_order SET fl_status=1 WHERE (orderid=uid_orderid);
INSERT INTO pre_adjfx_fl (uid, order_id, fl_value) VALUES (leader_uid, uid_orderid, (uid_price*2.5));

END