mysql count query

Question

I have a mysql table set up like this

id | refference_id | data

Is it possible to count the number of entries for each refference_id all in the query ?

Julien Hoarau · Accepted Answer · 2010-10-12 12:22:56Z

1

SELECT
  refference_id,
  COUNT(*)
FROM
  table
GROUP BY
  refference_id

answered Oct 12, 2010 at 12:22

Julien Hoarau

50.2k20 gold badges134 silver badges117 bronze badges

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

1 Comment

yes! thank you. i didn't select the name of the table in the query just the count(*) part that's why it wasn't working :<

Peter Perháč · Accepted Answer · 2010-10-12 12:23:57Z

0

select count(distinct refference_id) as myResult from myTable;

answered Oct 12, 2010 at 12:23

Peter Perháč

20.8k23 gold badges129 silver badges153 bronze badges

not as i was looking for. it counts how many different refference_ids i have