From b04347f4f0f6f1f909fde9974bf2d60a4e2586b7 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 11 Oct 2016 11:04:28 +0800 Subject: [PATCH] mysql/core_company_get_by_name.sql --- mysql/core_company_get_by_name.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/mysql/core_company_get_by_name.sql b/mysql/core_company_get_by_name.sql index dae31df9..1b85d2ca 100644 --- a/mysql/core_company_get_by_name.sql +++ b/mysql/core_company_get_by_name.sql @@ -1,12 +1,12 @@ -DROP FUNCTION IF EXISTS company_get_by_name; +DROP FUNCTION IF EXISTS core_company_get_by_name; DELIMITER $$ -CREATE FUNCTION company_get_by_name(in_name VARCHAR(128)) RETURNS INT(11) DETERMINISTIC +CREATE FUNCTION core_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; + SELECT id INTO v_ret FROM core_company WHERE name = in_name LIMIT 1; RETURN v_ret; END $$ DELIMITER ; \ No newline at end of file -- 2.39.2