SQL query COUNT?

Question

PHP

Given:
users:
id | name
articles:
id | user_id | title | name
Required:
users:
id | name | articles_count
where articles_count is the number of news from one user.

Answer 1

You can do this , but it's better to make a separate field / table and recalculate when adding / deleting.

Answer 2

select a.id, a.name, count(b.id) from users a
left join articles b on b.user_id = a.id
group by a.id, a.name

here is how it works