Re^9: How to add columns with new row name using perl from mysql query?

[Corion]

So, just add the alias and you're done.

Most likely, your SQL manual for your database will have the relevant information.

[finddata]

Am newbie in using alias how to use alias for this query?.I had google it but i didnt get good view.

[Corion]

Have you looked in the documentation of your database? Certainly the syntax is explained there.

[finddata]

select queue_name,jobs_pending,jobs_running from((select queue_name,jo
+bs_pending,jobs_running from queues order by queue_name limit 5)union
+ all(select 'others',sum(jobs_pending) int as jobs_pending,sum(jobs_r
+unning) as jobs_running from (select jobs_pending,jobs_running from q
+ueues order by queue_name limit 0 offset 5 ) foo)) foo;

The above thing now works for me.But the problem is others row not have the data type.So it prints NULL.How can i add data type along with 'others' row.