AS附近的mySQL错误

Question

有人可以帮忙吗？我刚刚切换了网络服务器，我正在测试一切正常，但我看到了这个错误。查询有什么问题吗？它似乎在我的上一个主机上有效

Critical Error
        A database error has occoured.
        Error Returned mySQL query error: SELECT f.* AS fixtures,
                    team1.teamName AS HomeTeam,
                    team1.tid AS HomeTeamID,
                    team2.teamName AS AwayTeam,
                    team2.tid AS AwayTeamID,
       GROUP_CONCAT(n.extra separator ',') AS scorers,
       GROUP_CONCAT(n.homeEvent separator ',') AS homeEvent,
       GROUP_CONCAT(n.eventType separator ',') AS eventType
    FROM fixtures f
    LEFT JOIN notifications n ON n.fixtureID = f.fid
    LEFT JOIN teams team1 ON team1.tid = f.HomeTeam
    LEFT JOIN teams team2 ON team2.tid = f.AwayTeam
    WHERE f.kickoff > 1403823600 AND f.lid=1
    GROUP BY f.fid
    ORDER BY n.time ASC, f.kickoff ASC

mySQL 错误:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS fixtures, team1.teamName AS HomeTeam, team1.tid AS HomeTeamID, ' at line 1

Answer 1

你不能像那样转换通配符..转换仅适用于单个字段

SELECT f.* AS fixtures

尝试类似的东西

SELECT f.fixtures AS fixtures, f.field AS field

等等