工作台SELECT语句错误：此位置的SELECT无效

由 eipsum发布于 2020-04-09 03:14:47

有人可以指出我正在犯什么错误。它给出以下错误。

此服务器版本的当前位置处的“选择”无效

SELECT (CONCAT(first_name,' ',last_name) AS fullName),
        DATE_FORMAT(last_update,'%m%d%y') AS LastUpdated,
FROM sakila.actor;

taut

2020-04-09 03:14:48

You have unwanted parentheses around the first expression in the SELECT clause (that wrongly include the column alias), and a trailing comma before FROM.

考虑：

SELECT 
    CONCAT(first_name,' ',last_name) AS fullName, 
    DATE_FORMAT(last_update, '%m%d%y') AS LastUpdated
FROM sakila.actor;

eipsum

这家伙很懒，什么都没留下

积分
0
话题
0
评论
3219
注册排名
1566