On Tue, Feb 10, 2009 at 1:29 PM, Cantwell, Bryan <bcantw...@firescope.com> wrote: > I am trying to put the result of a function that returns MEDIUMTEXT into > a user variable in my procedure. I haven't attempted to push the limits > of the MEDIUMTEXT size, but wonder if the user variable can even handle > this?
The REPEAT() function helps here: mysql> set @var := repeat('a', 1024 * 1024); Query OK, 0 rows affected (0.05 sec) mysql> select length(@var); +--------------+ | length(@var) | +--------------+ | 1048576 | +--------------+ 1 row in set (0.01 sec) So it accepts a mebibyte, let's see if we can notch that up :) mysql> set @var := repeat('a', 1024 * 1024 * 1024); Query OK, 0 rows affected, 1 warning (0.00 sec) mysql> show warnings; +---------+------+------------------------------------------------------------------------------+ | Level | Code | Message | +---------+------+------------------------------------------------------------------------------+ | Warning | 1301 | Result of repeat() was larger than max_allowed_packet (16777216) - truncated | +---------+------+------------------------------------------------------------------------------+ 1 row in set (0.00 sec) -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org