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

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

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

Replies are listed 'Best First'.
Re^12: How to add columns with new row name using perl from mysql query? by finddata (Sexton) on Apr 07, 2017 at 05:28 UTC
`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;` [download] 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.	[reply] [d/l]
Re^13: How to add columns with new row name using perl from mysql query? by poj (Abbot) on Apr 07, 2017 at 06:46 UTC
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`	[reply] [d/l]