MySQL how to get number of values from a user? -

MySQL how to get number of values from a user? -

i have 3 tables:

users: user_id|user_nick 1 | 2 | b category: cat_id|cat_type 1 | 2 | b 3 | c 4 | d meta: met_id|met_name|met_user|met_type 10 | bla | 1 | 1 11 | blabla | 2 | 2 12 | foo | 1 | 3 13 | blafoo | 2 | 4 14 | foofoo | 1 | 4 15 | foobla | 1 | 4

how can homecoming ?

user_id|met_type|total 1 | 1 | 1 1 | 2 | 0 1 | 3 | 1 1 | 4 | 2

for 1 user , not of them.

met_type foreign key category.

i've tried no success :/

select met_user, met_type, count(*) meta grouping met_user met_user = '1'

query:

select met_user, met_type, count(*) meta met_user='1' grouping met_type;

to empty groups, can utilize generateseries() here:

select m.met_user, g.meta_type, count(m) generate_series(1, 4) g(meta_type) left outer bring together meta m on m.met_user='1' , m.met_type=g.meta_type grouping g.meta_type, m.met_user order g.meta_type;

check out! made sql fiddle.

mysql