DELIMITER |
DROPPROCEDUREIFEXISTS update_conference_status |
CREATEPROCEDURE update_conference_status()
BEGINIFexists (select id from conference where`status`='1'and SYSDATE()>=start_time) THENupdate conference set`status`='2'where id in (select id from (select id from conference where`status`='1'and SYSDATE()>=start_time) as tmp1);ENDIF;
IF exists (select id from conference where`status`='2'and SYSDATE()>=end_time) THENupdate conference set`status`='0'where id in (select id from (select id from conference where`status`='2'and SYSDATE()>=end_time) as tmp2);ENDIF;END
|
DELIMITER;