mysql - 尝试从 Symfony2 中的数据库获取列总和时出错

Question

我正在尝试获取数据库列中多个值的总和:

                $goalsScored = $em->createQueryBuilder()
                ->select('sum(homeGoals)')
                ->from('LoginLoginBundle:Matchgame', 'mg')
                ->where("mg.homeTeam LIKE '" . $oneTeam->getTeamid()."'")
                ->getQuery()
                ->getSingleScalarResult();

我收到以下错误:

[Semantical Error] line 0, col 11 near 'homeGoals) FROM': Error: 'homeGoals' is not defined. 

homeGoals 是在我的数据库中定义的，那么为什么会出现此错误？是因为有些值是空的吗？

Answer 1

您的选择中缺少表别名:

    $goalsScored = $em->createQueryBuilder()
    ->select('sum(mg.homeGoals)')
    ->from('LoginLoginBundle:Matchgame', 'mg')
    ->where("mg.homeTeam LIKE '" . $oneTeam->getTeamid()."'")
    ->getQuery()
    ->getSingleScalarResult();