大家好,幫我看看下面的mysql的函數(shù)有什么問(wèn)題?一直創(chuàng)建不了.

DELIMITER $$

DROP FUNCTION IF EXISTS check_if_exists$$

CREATE FUNCTION check_if_exists

(

object_name VARCHAR(100),

db_name VARCHAR(100),

object_type enum('t', 'f', 'v', 'p')

)

RETURNS INT

BEGIN

IF (object_type='t') THEN

SELECT COUNT(1) INTO @f_result

from information_schema.TABLES as t1

where t1.TABLE_SCHEMA=db_name

and t1.TABLE_NAME=object_name;

ELSE IF (object_type='f') THEN

select count(1) INTO @f_result

FROM information_schema.ROUTINES as info

WHERE info.ROUTINE_SCHEMA = db_name

AND info.ROUTINE_TYPE = 'FUNCTION' AND info.ROUTINE_NAME = object_name;

ELSE IF (object_type='v') THEN

select count(1) into @f_result

from information_schema.VIEWS as t1

where t1.TABLE_SCHEMA=db_name and t1.TABLE_NAME=object_name;

ELSE IF (object_type='p') THEN

SELECT COUNT(1) INTO @f_result

FROM information_schema.ROUTINES as info

WHERE info.ROUTINE_SCHEMA = db_name

AND info.ROUTINE_TYPE = 'PROCEDURE'

AND info.ROUTINE_NAME = object_name;

END IF;

return @f_result;

END$$

delimiter ;

總結(jié)

以上是生活随笔為你收集整理的mysql创建函数失败_mysql创建函数出现问题?的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。