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

Is it possible..

Yes

Without modifying while loop..

No ( unless you make the SQL more complex )

Note the error message for your select is still wrong here

$sth->execute() or print "Could not in7sert_run_pend data";

poj

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

Replies are listed 'Best First'.
Re^4: How to add columns with new row name using perl from mysql query? by finddata (Sexton) on Apr 06, 2017 at 12:45 UTC
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.	[reply]
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	[reply]