mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i686) using readline 5.0
Connection id: 94
Current database: saga
Current user: saga@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.0.27-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: euckr
Db characterset: euckr
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 15 days 15 hours 10 min 15 sec
Threads: 3 Questions: 2243 Slow queries: 0 Opens: 227 Flush tables: 1 Open tables: 23 Queries per second avg: 0.002
--------------
mysql 버전이구요..
centos에 설치되어 있습니다.
생성하려는 함수는 아래와 같습니다.
CREATE FUNCTION getCodeName(V_CODE_GROUP VARCHAR(3), V_CODE_DETAIL VARCHAR(3)) RETURNS VARCHAR(200)
BEGIN
DECLARE V_CODENAME VARCHAR(200);
SELECT CODE_NAME INTO V_CODENAME FROM TB_CODE WHERE CODE_GROUP = V_CODE_GROUP AND CODE_DETAIL = V_CODE_DETAIL AND USE_YN = 'Y';
RETURN V_CODENAME;
END;
에러는 아래와 같이 발생 합니다.
MySQL Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'RETURN V_CODENAME' at line 1
도움 부탁드립니다.
|