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

Replies are listed 'Best First'.
Re^3: How to add columns with new row name using perl from mysql query? by choroba (Cardinal) on Apr 03, 2017 at 11:16 UTC
Because you want to sum over all the remaining rows, but you don't know their number. So I used the maximal possible number of rows, as shown in the documentation. ($q=q:Sq=~/;[c](.)(.)/;chr(-\|\|-\|5+lengthSq)`"S\|oS2"`map{chr \|+ord }map{substrSq`S_+\|`\|}3E\|-\|`7**2-3:)=~y+S\|`+$1,++print+eval$q,q,a, [download]	[reply] [d/l]
Re^4: How to add columns with new row name using perl from mysql query? by Anonymous Monk on Apr 03, 2017 at 11:30 UTC
Offset without limit ?	[reply]
Re^5: How to add columns with new row name using perl from mysql query? by choroba (Cardinal) on Apr 03, 2017 at 12:21 UTC
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OFFSET 5' at line ... ($q=q:Sq=~/;[c](.)(.)/;chr(-\|\|-\|5+lengthSq)`"S\|oS2"`map{chr \|+ord }map{substrSq`S_+\|`\|}3E\|-\|`7**2-3:)=~y+S\|`+$1,++print+eval$q,q,a, [download]	[reply] [d/l]
Re^6: How to add columns with new row name using perl from mysql query? by Anonymous Monk on Apr 03, 2017 at 17:37 UTC
Re^7: How to add columns with new row name using perl from mysql query? by afoken (Chancellor) on Apr 03, 2017 at 19:07 UTC