这个MySQL存储过程中的语法错误在哪里?
问题描述:
我想将输出参数名称设置为串联的kund.Vorname和kund.Nachname.但是我遇到语法错误,但找不到.我将不胜感激.
I want to set the output parameter name to the concatenated kund.Vorname and kund.Nachname. But I get a syntax error and I can't find it. I'd appreciate any help.
CREATE PROCEDURE GetName(IN kartennummer CHAR(16), OUT name VARCHAR(91))
BEGIN
SELECT @name = (CONCAT_WS(' ', kund.Vorname, kund.Nachname)
FROM Kunden kund,
Konten kont
WHERE kund.KundenID = kont.KundenID AND
kont.Kartennummer = kartennummer));
END;
答
而且,根据上下文,您可能需要 DELIMITER
语句.
And, depending on context, you may need a DELIMITER
statement.