我有一个问题:
SELECT msg
FROM msgs
WHERE topic='$topic'
ORDER BY likes_a ASC我需要计算有多少行WHERE topic='$topic'
我该怎么算呢?
发布于 2016-06-15 00:25:12
当您将查询告知SELECT msg时,您就是在告诉它选择符合条件的所有消息并返回它们。当您将其更改为SELECT COUNT(msg)时,您只是询问符合条件的msg数量。
SELECT COUNT(msg)
FROM msgs
WHERE topic='$topic' 发布于 2016-06-15 02:00:21
您只需编写以下不带order by的查询
SELECT COUNT(msg) FROM msgs WHERE topic='$topic';这是一个平面SQL查询,将工作在MySQL,MS SQL服务器等有任何问题。
https://stackoverflow.com/questions/37817417
复制相似问题