DELIMITER $$

CREATE PROCEDURE selectContacts

BEGIN

SELECT master_id, CONCAT_WS(" ",l_name, f_name) AS display_name

FROM master_name

ORDER BY l_name, f_name;

END

错误：

# 1064 - Something is wrong in your syntax obok 'BEGIN

SELECT master_id, CONCAT_WS(" ",l_name, f_name) AS display_name

FROM' at line 3

Unrecognized data type. (near " " at position 75)
Unrecognized data type. (near ")" at position 90)

无法识别的数据类型位于的括号中 concat_ws . 我不知道它出了什么问题，因为它是工作2个月前。