触发器语法错误求指教

2013-06-17 07:46:28 214 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

java程序创建mysql触发器最近在工作中要动态的创建表和相应的触发器，特此记录下。阅读详情



create FUNCTION f_get_triggerinfo(v_alarm_event_id  int) returns int

begin  

declare v_ret int;

select

(case when (exists (select 1 from alarm_trigger_client where  alarm_event_id=alarm_event.alarm_event_id and valid_flag='1')) then 1 else 0 end  case)

+

(case when (exists (select 1 from alarm_trigger_email where  alarm_event_id=alarm_event.alarm_event_id and valid_flag='1')) then 10 else 0 end case)

+

(case when (exists (select 1 from alarm_trigger_io where  alarm_event_id=alarm_event.alarm_event_id and valid_flag='1')) then 100 else 0 end case)

+

(case when (exists (select 1 from alarm_trigger_message where  alarm_event_id=alarm_event.alarm_event_id and valid_flag='1')) then 1000 else 0 end case)

+

(case when (exists (select 1 from alarm_trigger_popup_video where  alarm_event_id=alarm_event.alarm_event_id and valid_flag='1')) then 10000 else 0 end case)

+

(case when (exists (select 1 from alarm_trigger_preset where  alarm_event_id=alarm_event.alarm_event_id and valid_flag='1')) then 100000 else 0 end case)

+

(case when (exists (select 1 from alarm_trigger_tvwall where  alarm_event_id=alarm_event.alarm_event_id and valid_flag='1')) then 1000000 else 0 end case)

+

(case when (exists (select 1 from alarm_trigger_vrm where  alarm_event_id=alarm_event.alarm_event_id and valid_flag='1')) then 10000000 else 0 end case)

 into v_ret

 from alarm_event where alarm_event_id=v_alarm_event_id;

return v_ret;

end;