Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

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

by finddata (Sexton)
on Apr 06, 2017 at 13:40 UTC ( #1187283=note: print w/replies, xml ) Need Help??


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

Am newbie in using alias how to use alias for this query?.I had google it but i didnt get good view.
  • Comment on Re^10: How to add columns with new row name using perl from mysql query?

Replies are listed 'Best First'.
Re^11: How to add columns with new row name using perl from mysql query?
by Corion (Pope) on Apr 06, 2017 at 13:42 UTC

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

      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.

        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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1187283]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (9)
As of 2019-12-06 15:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Strict and warnings: which comes first?



    Results (156 votes). Check out past polls.

    Notices?