This may be due to 'max_allowed_packet' size ... have a look at

http://www.mysql.com/doc/P/a/Packet_too_large.html

This is configurable

Regards,
Dan.


> -----Original Message-----
> From: Alain Fontaine - Consultant and developer
> [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 8 February 2002 1:30 a.m.
> To: 'MySQL list (E-mail)'
> Subject: RE: long query on php
> 
> 
> Have you tried just putting the querys into a variable and pass the var
> along to mysql_query() ? Did it not work?
> 
> -----------------------
> Alain Fontaine
> Consultant & Developer
> VAlain S.A.
> Tel: +32-4-2522950
> -----------------------
> 
> -----Original Message-----
> From: savaidis [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 06, 2002 8:14 PM
> To: MySQL list (E-mail)
> Subject: long query on php
> 
> 
> 
> How is possible to pass a long query to MySQL server with php?
> I mean i.e a "create table" statement with more than 400 chars.
> Have I to use shorter "create" and then "alter"?
> 
> Thanks
> Makis
> 
> 
> ---------------------------------------------------------------------
> 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
> 
> 
> ---------------------------------------------------------------------
> 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

Reply via email to