From 0d8d3522c55d70c3b1ef1aa52461e753c7af007e Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 17 Nov 2014 14:50:43 +0800 Subject: [PATCH] mysql/core_enum_id_by_name.sql mysql/core_enum_functions.sql --- mysql/core_enum_id_by_name.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 mysql/core_enum_id_by_name.sql diff --git a/mysql/core_enum_id_by_name.sql b/mysql/core_enum_id_by_name.sql new file mode 100644 index 00000000..da83c8dc --- /dev/null +++ b/mysql/core_enum_id_by_name.sql @@ -0,0 +1,13 @@ + +DROP FUNCTION IF EXISTS core_enum_id_by_name; +DELIMITER $$ +CREATE FUNCTION core_enum_id_by_name(in_etype VARCHAR(256), in_name VARCHAR(256)) + RETURNS INT(11) DETERMINISTIC + BEGIN + DECLARE ret INT(11); + SET ret = ''; + SELECT id INTO ret FROM core_enum + WHERE name=in_name AND etype=in_etype LIMIT 1; + RETURN ret; + END $$ +DELIMITER ; \ No newline at end of file -- 2.39.2