Surprisingly it is mote than 64 KB! (I count strlen=74KB) Bravo!! Makis
> -----Original Message----- > From: savaidis [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 08, 2002 9:08 AM > To: [EMAIL PROTECTED]; 'Nathan' > Cc: 'MySQL' > Subject: RE: long query on php > > > > Just a comment: > Doing so it's possible to insert a line between $query...... > statements. > (comments ecc) Its very simple to write it with copy+paste > and I prefer > this. > Thanks. > > PS. I'll check the string limit and I let you know. I think > it has to be the > 64KB. > I think only Visual Basic has this high limit, no? > > Makis > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 08, 2002 3:03 AM > > To: Nathan > > Cc: MySQL > > Subject: Re: long query on php > > > > > > Hi. > > > > I prefer doing like this > > $query = "CREATE TABLE query "; > > $query .= "tabledef for col a,"; > > $query .= "tabledef for col b,"; > > $query .= "lots more table defs,"; > > $query .= "welcome to line 400"; > > > > You get the point i guess > > you can do same things many different ways in php:) > > > > /PM\ > > > > Alex Aulbach wrote: > > > > > > Yesterday, from Nathan: > > > > > > > Since PHP ignores whitespace, I think this is also acceptable: > > > > > > PHP doesn't ignore whitespace in a quote. But your code > is of course > > > correct. > > > > > > > $query = "CREATE TABLE query > > > > tabledef for col a, > > > > tabledef for col b, > > > > lots more table defs, > > > > ..... > > > > welcome to line 400"; > > > > > > Another way: (without test) > > > > > > $bladefault=24; > > > $query = <<<eoq; > > > CREATE TABLE query ( > > > id char(2) default "24" # doublequotes work > > > hugo char(2) default '24' # singlequotes work either > > > bla char(2) default '$bladefault' # inline vars work > > > ... > > > ) > > > eoq > > > > > > -- > > > > 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"? > > > > > > Strings in PHP can be really, really long and are binary > > safe. Perhaps the > > > problem is the editor? > > > > > > -- > > > > > > SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris > > > > > > > > > --------------------------------------------------------------------- > > > 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
