From 6de370d11e54351cde549286784d92cd93d48865 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 11 Oct 2016 11:04:18 +0800 Subject: [PATCH] MOVED mysql/company_get_by_name.sql to mysql/core_company_get_by_name.sql --- mysql/core_company_get_by_name.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 mysql/core_company_get_by_name.sql diff --git a/mysql/core_company_get_by_name.sql b/mysql/core_company_get_by_name.sql new file mode 100644 index 00000000..dae31df9 --- /dev/null +++ b/mysql/core_company_get_by_name.sql @@ -0,0 +1,12 @@ + + +DROP FUNCTION IF EXISTS company_get_by_name; +DELIMITER $$ +CREATE FUNCTION company_get_by_name(in_name VARCHAR(128)) RETURNS INT(11) DETERMINISTIC + BEGIN + DECLARE v_ret INT(11); + SET v_ret= 0; + SELECT id INTO v_ret FROM Companies WHERE name = in_name LIMIT 1; + RETURN v_ret; + END $$ +DELIMITER ; \ No newline at end of file -- 2.39.2