mysql select id and count in one command?

Question

Using Mysql How would i merge these two commands into one?

select id from User where name='name' select count(*) from Msg where user_id=@id

Zane Bien · Accepted Answer · 2012-07-14 22:06:30Z

3

You can join the tables:

SELECT COUNT(*) FROM User a INNER JOIN Msg b ON a.id = b.user_id WHERE a.name = 'name'

answered Jul 14, 2012 at 22:06

23.2k6 gold badges47 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1