day, 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
Yesterday, from savaidis:
> The obious question is: (before I test it)
> This is concatenation to $query that is a string type, no?
Yea. The following works either:
mysql_query("create bla".
"bla".
"bla
bla blabla
".
"bla"
."bla"
);
> So the limit isn't
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 wro
nd before the closing quotations) if you plan on continuing the query on
the next line, or else your SQL will be invalid.
Good luck,
Brett
Original Message Follows
From: "savaidis" <[EMAIL PROTECTED]>
To: "MySQL list \(E-mail\)" <[EMAIL PROTECTED]>
l those lines are actually
just one line.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Brett Burgess [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 11:25 AM
To: [EMAIL PROTECTED]
Subject: Re: long query on php
He
It shouldn't be a problem as long as the syntax is right...
Gurhan
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:14 PM
To: MySQL list (E-mail)
Subject: long query on php
How is possible to pass a long query to MySQL server wit
MAIL 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 the
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:
ht
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
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 t
c 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
CTED]>, <[EMAIL PROTECTED]>
Subject: RE: long query on php
Date: Thu, 7 Feb 2002 22:29:47 +0200
The obious question is: (before I test it)
This is concatenation to $query that is a string type, no?
So the limit isn't also set to 255 chars too?
Or is a trick especially for this case?
, it's all
on the same line.
# Nathan
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 10:36 AM
Subject: RE: long query on php
Or you could do it like this:
$query="some query "
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
c 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
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 t
Yesterday, from savaidis:
> The obious question is: (before I test it)
> This is concatenation to $query that is a string type, no?
Yea. The following works either:
mysql_query("create bla".
"bla".
"bla
bla blabla
".
"bla"
."bla"
);
> So the limit isn't
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 wro
CTED]>, <[EMAIL PROTECTED]>
Subject: RE: long query on php
Date: Thu, 7 Feb 2002 22:29:47 +0200
The obious question is: (before I test it)
This is concatenation to $query that is a string type, no?
So the limit isn't also set to 255 chars too?
Or is a trick especially for this case?
Sent: Thursday, February 07, 2002 7:36 PM
> To: [EMAIL PROTECTED]
> Subject: RE: long query on php
>
>
>
> Or you could do it like this:
>
> $query="some query "
> ."some more of this query "
> ."still some more query "
>
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 F
, it's all
on the same line.
# Nathan
- Original Message -
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 07, 2002 10:36 AM
Subject: RE: long query on php
Or you could do it like this:
$query="some query "
l those lines are actually
just one line.
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Brett Burgess [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 11:25 AM
To: [EMAIL PROTECTED]
Subject: Re: long query on php
He
nd before the closing quotations) if you plan on continuing the query on
the next line, or else your SQL will be invalid.
Good luck,
Brett
Original Message Follows
From: "savaidis" <[EMAIL PROTECTED]>
To: "MySQL list \(E-mail\)" <[EMAIL PROTECTED]>
MAIL 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 the
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:
ht
26 matches
Mail list logo
