From 80aa70567f1b7e9f34c2c74e1382a36f8eb0a7a9 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 11 Oct 2016 11:06:29 +0800 Subject: [PATCH] MOVED mysql/person_get_action_type.sql to mysql/core_person_get_action_type.sql --- mysql/core_person_get_action_type.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 mysql/core_person_get_action_type.sql diff --git a/mysql/core_person_get_action_type.sql b/mysql/core_person_get_action_type.sql new file mode 100644 index 00000000..dcd36804 --- /dev/null +++ b/mysql/core_person_get_action_type.sql @@ -0,0 +1,13 @@ + +DROP FUNCTION IF EXISTS person_get_action_type; + +DELIMITER $$ +CREATE FUNCTION person_get_action_type(in_id INT(11)) RETURNS VARCHAR(32) DETERMINISTIC + BEGIN + + DECLARE v_ret VARCHAR(32); + SET v_ret= ''; + SELECT action_type INTO v_ret FROM Person WHERE id = in_id LIMIT 1; + RETURN v_ret; + END $$ +DELIMITER ; -- 2.39.2