mysql function1

• 

  [mysql] MYSQL CREATE FUNCTION 에러 MYSQL CREATE FUNCTION 에러 아래와 같은 FUNCTION을 생성시키려 할 때, CREATE DEFINER=`test`@`%` FUNCTION `GET_CREATE_ID`( `tableName` VARCHAR(50) ) RETURNS char(6) CHARSET utf8 LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'ID 생성 함수' BEGIN DECLARE id VARCHAR(50); UPDATE T_ID_GENERATION SET NEXT_ID = NEXT_ID + 1 WHERE TABLE_NAME = tableName; SET id = ( SELECT CONCAT(IFNULL(PREFIX,''), L.. DB/MySql 2018. 6. 8.