Mysql错误说 "an expression was expected near FROM"

Question

SELECT users.name,
phone_info.phone_num,
FROM users LEFT OUTER JOIN phone_info
ON users.user_id = phone_info.user_id

我的数据库 users 和 phone_info 中有 2 个表。我想用左连接来执行有数字的用户。但是我得到这样的错误

Static analysis:

1 errors were found during analysis.

An expression was expected. (near "FROM" at position 43)
SQL query: Documentation

SELECT users.name, phone_info.phone_num, FROM users LEFT JOIN phone_info ON 
users.user_id = phone_info.user_id

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that 
corresponds to your MariaDB server version for the right syntax to use near 
'FROM users LEFT JOIN phone_info
ON users.user_id = phone_info.user_id' at line 3

Answer 1

去除 FROM 前多余的逗号

SELECT users.name,
phone_info.phone_num
FROM users LEFT OUTER JOIN phone_info
ON users.user_id = phone_info.user_id