MySQL CReate 函数语法错误
我正在尝试使用 phpmyadmin/mysql 控制台创建函数。没有任何运气。我收到语法错误的信息。
有人可以看一下这个功能吗？
CREATE FUNCTION fnCategoryList
(
@NewsID INT
)
RETURNS VARCHAR(1000)
AS
BEGIN
DECLARE @CategoryList VARCHAR(1000)
SET @CategoryList = ''
SELECT @CategoryList = COALESCE(@CategoryList + ',','') + C.[Name]
FROM news_categories AS NC
INNER JOIN categories AS C
ON NC.CategoryID = C.ID
WHERE NC.NewsID = @NewsID
RETURN @CategoryList
END
I'm trying to create function using phpmyadmin/mysql console. Without any luck. I'm getting info of syntax error.
Can anybody take a look on this function?
CREATE FUNCTION fnCategoryList
(
@NewsID INT
)
RETURNS VARCHAR(1000)
AS
BEGIN
DECLARE @CategoryList VARCHAR(1000)
SET @CategoryList = ''
SELECT @CategoryList = COALESCE(@CategoryList + ',','') + C.[Name]
FROM news_categories AS NC
INNER JOIN categories AS C
ON NC.CategoryID = C.ID
WHERE NC.NewsID = @NewsID
RETURN @CategoryList
END
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
这不是 MySQL 函数的正确语法。这就是您收到语法错误的原因。
http://dev.mysql.com/doc/refman/5.0 /en/create-procedure.html
您是否尝试从其他 RDBMS 复制此内容？
This is not correct syntax for a MySQL function. That's why you get a syntax error.
http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html
Did you try to copy this from a different RDBMS?