如何在Doctrine2中执行MySQL count（*）？ [英] How would I do MySQL count(*) in Doctrine2?

问题描述

我有以下Doctrine2查询：

I have the following Doctrine2 query:

$qb = $em->createQueryBuilder()
      ->select('t.tag_text, COUNT(*) as num_tags')
      ->from('CompanyWebsiteBundle:Tag2Post', 't2p')
      ->innerJoin('t2p.tags', 't')
      ->groupBy('t.tag_text')
;
$tags = $qb->getQuery()->getResult();

运行时出现以下错误：

[Semantical Error] line 0, col 21 near '*) as num_tags': Error: '*' is not defined. 

如何在Doctrine2中执行MySQL count（*）？

How would I do MySQL count(*) in Doctrine2?

推荐答案

你试图在DQL中做不要在Doctrine 2中。

You're trying to do it in DQL not "in Doctrine 2".

指定要计算哪个字段（请注意，我不使用术语列），这是因为您正在使用ORM，并且需要以OOP方式思考。

You need to specify which field (note, I don't use the term column) you want to count, this is because you are using an ORM, and need to think in OOP way.

$qb = $em->createQueryBuilder()
      ->select('t.tag_text, COUNT(t.tag_text) as num_tags')
      ->from('CompanyWebsiteBundle:Tag2Post', 't2p')
      ->innerJoin('t2p.tags', 't')
      ->groupBy('t.tag_text')
;
$tags = $qb->getQuery()->getResult();

但是，如果您需要性能，可能需要使用 NativeQuery ，因为你的结果是简单的标量不是一个对象。

However, if you require performance, you may want to use a NativeQuery since your result is a simple scalar not an object.

这篇关于如何在Doctrine2中执行MySQL count（*）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！