MySQL查询问题求助

Question

像这样,一个提问表,question,reply(当然可能不是这样设计的) question id title user time …… reply id q_id //问题ID user time …… 怎么一次查询出 问题title,时间,回答次数? 又例如学生表,成绩表如...

PHPz · Answer

select users.user,users.name,(select count(*) from grade where users.user=grade.user) 
as total from users;

指定班級:

select users.user,users.name,(select count(*) from grade where users.user=grade.user) 
as total
from users where user like '2012%';

黄舟 · Answer

SELECT question.title, question.time,
(SELECT COUNT(*) FROM reply WHERE reply.q_id = question.id) AS reply_sum
FROM question

下面的問題類似

php8，我來也