我如何打印计数结果和表一起在mysql?

Question

如何在mysql中打印计数结果和表?

SELECT friendName from Friend where userId = 'kdw8055' and type = 'F' and status = 'Y';
SELECT COUNT(*) from Friend where userId = 'kdw8055' and type = 'F' and status = 'Y';

我想马上打印上面的结果。我该怎么办?

Answer 1

如果您想在单行中显示，您可以使用简单的GROUP BY。

SELECT friendName, count(*) from Friend 
where userId = 'kdw8055' and type = 'F' and status = 'Y'
GROUP BY friendname;