There is a limit to the size of a packet sent to mysqld, which is
configurable. Check the manual for it, and see if you are hitting that.

Regards

Quentin

> -----Original Message-----
> From: Mark Dale [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 12, 2001 12:39 PM
> To:   [EMAIL PROTECTED]
> Subject:      limit to the number of characters allowed in a query?
> 
> I'm trying to run a very long query and after trying it in various 
> ways, it seems like there is a limit to the number of characters 
> allowed in a query.
> 
> If this is true, is it possible to increase the number of characters
> allowed.
> (the database is hosted at an ISP)
> 
> I've tried -q and -f in the query, but it didnt help
> 
> TIA
> 
> Mark Dale
> 
> ---------------------------------------------------------------------
> 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

The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended 
recipient, you are asked to respect that confidentiality and not 
disclose, copy or make use of its contents. If received in error 
you are asked to destroy this email and contact the sender immediately. 
Your assistance is appreciated.

---------------------------------------------------------------------
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

Reply via email to