in reply to Re: return string from query (DBI, MySQL) got truncated when trying to generating statement dynamically for MySQL
in thread return string from query (DBI, MySQL) got truncated when trying to generating statement dynamically for MySQL

It turns out the limit for the concat string is set by mySQL.

After set group_concat_max_len to a big number, the query works fine.

$sth = $dbh->do('SET @@group_concat_max_len = 320000')

[download]

Thank you all!

  • Comment on Re^2: return string from query (DBI, MySQL) got truncated when trying to generating statement dynamically for MySQL
  • Download Code

In Section Seekers of Perl Wisdom