MySQL Query 帮助，包括一个计数？

Question

知道为什么这在 MySQL 中不起作用吗？

SELECT blogentry.*, 
       person.personName, 
       (SELECT * 
          FROM BlogEntryComment 
         Where BlogEntryID = '8') as CommentCount    
  FROM blogentry 
 INNER JOIN person ON blogentry.personID = person.personID
 WHERE blogentry.deleted = 'N'
ORDER BY blogentry.dateAdded DESC

Answer 1

子查询只需要返回一个值:字段计数。 * 返回所有行，而 count(*) 将返回行数。

(SELECT count(*) FROM BlogEntryComment Where BlogEntryID = '8')