http://www.perlmonks.org?node_id=1187270


in reply to Re^3: 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?

Here i should not change the while loop.Without changing while loop, by using only sql query how can i do it?Will adding duplicate entries of the mysql rows and unique it will helps me.If it helps how can i do it mysql query.

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

Replies are listed 'Best First'.
Re^5: How to add columns with new row name using perl from mysql query?
by poj (Abbot) on Apr 06, 2017 at 13:37 UTC
    by using only sql query how can i do it

    Not a Perl question then ?

    Develop your SQL in MySQL Workbench (or other client) and then when it works put it in your perl script

    poj