From 1c8046016fa320606abe89d74eed744978253eeb Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 11 Oct 2016 11:06:52 +0800 Subject: [PATCH] MOVED mysql/person_get_by_email.sql to mysql/core_person_get_by_email.sql --- mysql/core_person_get_by_email.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 mysql/core_person_get_by_email.sql diff --git a/mysql/core_person_get_by_email.sql b/mysql/core_person_get_by_email.sql new file mode 100644 index 00000000..a098e615 --- /dev/null +++ b/mysql/core_person_get_by_email.sql @@ -0,0 +1,18 @@ + +DROP FUNCTION IF EXISTS person_get_by_email; + +DELIMITER $$ +CREATE FUNCTION person_get_by_email( + in_addr VARCHAR(254) + + + ) RETURNS INT(11) DETERMINISTIC + BEGIN + + DECLARE v_id INT(11); + SET v_id = 0; + SELECT id INTO v_id FROM Person WHERE email = in_addr LIMIT 1; + RETURN v_id; + + END $$ +DELIMITER ; -- 2.39.2