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 choroba (Archbishop) 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
I should manually check?	[reply]
Re^7: How to add columns with new row name using perl from mysql query? by afoken (Canon) on Apr 03, 2017 at 19:07 UTC
choroba++ just shows that MySQL does not accept `OFFSET` without `LIMIT` by quoting the error message from MySQL. Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply] [d/l] [select]


We don't bite newbies here... much
	PerlMonks