in reply to Re^2: storing queries in an array and execute
in thread storing queries in an array and execute

Ah, then keep the qx and remove the Dumper.

But you should use DBI with DBD::mysql instead of shelling out.

($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,

Replies are listed 'Best First'.
Re^4: storing queries in an array and execute
by kaka_2 (Sexton) on Nov 25, 2016 at 10:57 UTC

    if i remove Dumper then also it gives error and that i why i thougt to use Dumper.

    with DBI, i have Problem with missing Module DBD and that i why i am trying out directly with mysql -e.

      > if i remove Dumper then also it gives error and that i why i thougt to use Dumper.

      It would be helpful to include the error here, too. It seems it was the following one:

      sh: -c: line 0: syntax error near unexpected token `0x20fca70' sh: -c: line 0: `SCALAR(0x20fca70)' sh: -c: line 0: syntax error near unexpected token `0x20fcab8' sh: -c: line 0: `SCALAR(0x20fcab8)'

      You should also remove backslashes from the array assignment. Backslash creates a reference.

      my @QXXXX = ( $Query1, $Query2 );

      ($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,

      Are you having problems installing the module? If so what are they?