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

[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.

[poj]

Read the docs here and search for the phrase

To retrieve all rows from a certain offset up to the end of the result set