From 26e0957ea8e3cb12f471e988e59ac3a811c0e612 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 16 Apr 2015 13:23:50 +0800 Subject: [PATCH] mysql/core_enum_trigger_check.sql --- mysql/core_enum_trigger_check.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/mysql/core_enum_trigger_check.sql b/mysql/core_enum_trigger_check.sql index e69de29b..5e79ad75 100644 --- a/mysql/core_enum_trigger_check.sql +++ b/mysql/core_enum_trigger_check.sql @@ -0,0 +1,11 @@ + + +CREATE PROCEDURE core_enum_trigger_check (i_etype VARCHAR(128) , i_id INT) + BEGIN + DECLARE v_cnt INT; + SET v_cnt = 0; + SELECT count(*) INTO v_cnt WHERE etype = i_etype, id = i_id; + IF (v_cnt < 1) THEN + UPDATE `Core Enum Does not exist` SET x = 1; + END; + -- 2.39.2