Wouldn't that be greater than the default maximum packet length of 1M? Octavian Rasnita wrote:
Hi all,
I've tried the "repeat" function for testing some tables, but it cannot
create very big strings.
Do you know which is its upper limit?
I've tried the following query:
mysql> select length(repeat('abracadabra', 100000));
+---------------------------------------+
| length(repeat('abracadabra', 100000)) |
+---------------------------------------+
| NULL |
+---------------------------------------+
1 row in set (0.00 sec)
If I use smaller numbers, it works.
Thank you.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
