> Hie i had the same issue on Monday but i used a view to kill it see if it
> might help
>
> 1) Create a View (my_table1 - 5 ) which pulls all the data you want in the
> World. Yote Yote
>
Hmm, I am afraid I don't see the point of your view in this case. You mind explaining a bit what's your intent for the views here?

I believe views are used to pre-process a data and hence allow quick response through a simply select when user request the data or to hind column(s) for security purpose. Your use don't fall in these two purpose, so I got a bit curious.

Muriithi
> 2) Use Below to Sum and Arrange  from the View
>
>  select `viewalltables`.`Products` AS `Products`,
>  sum((case when (`viewalltables`.`priority` = 'Immediate') then 1 else 0
> end)) AS `A`,
>  sum((case when (`viewalltables`.`priority` = 'Urgent') then 1 else 0 end))
> AS `B`,
>  sum((case when (`viewalltables`.`priority` = 'High') then 1 else 0 end))
> AS `C`,
>  sum((case when (`viewalltables`.`priority` = 'Normal') then 1 else 0 end))
> AS `D`,
>  sum((case when (`viewalltables`.`priority` = 'Low') then 1 else 0 end)) AS
> `E`,
>  sum((case when (`viewalltables`.`name` = 'New') then 1 else 1 end)) AS `F`,
>  sum((case when (`viewalltables`.`name` = 'Closed') then 1 else 0 end)) AS
> `G`,
>  sum((case when (`viewalltables`.`name` = 'Resolved') then 1 else 0 end))
> AS `H`
>  from `viewalltables`
>  group by `viewalltables`.`Products`;
>
> 3) i think it can cook well
>
>
>
>
>
>
> On Thu, Aug 1, 2013 at 9:31 AM, Peter Karunyu <pkarunyu@gmail.com> wrote:
>
> > I have a table with 10 columns, and about 20,000 rows.
> >
> > I want to get the count of the distinct values in 5 of the columns, so
> > normally, I would probably write 5 queries thus:
> >
> > SELECT column_a, count(column_a) FROM my_table GROUP BY column_a;
> > SELECT column_b, count(column_b) FROM my_table GROUP BY column_b;
> > SELECT column_c, count(column_c) FROM my_table GROUP BY column_c;
> > SELECT column_d, count(column_d) FROM my_table GROUP BY column_d;
> > SELECT column_e, count(column_e) FROM my_table GROUP BY column_e;
> >
> > My question is, is there a way I can do this in a more generic/future
> > proof way?
> >
> > Maybe a stored procedure which I just pass the table name to? Or some PHP
> > function which I just give the name of the table to?
> >
> > Ultimate goal is to write just one query to get the above data.
> >
> > ______________________________________