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]
Subject: long query on php
Date: Wed, 6 Feb 2002 21:13:44 +0200
How is possible to pass a long
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 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 also set to
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
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
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:
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
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 with php
.
-
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
Here is how I do it:
$query = some query ;
$query
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
.some more of this query
.still some more query
[mailto:[EMAIL PROTECTED]]
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
.and so on and so forth...;
;
The tabs
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
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
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
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
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:
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
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]
Subject: long query on php
Date: Wed, 6 Feb 2002 21:13:44 +0200
How is possible to pass a long
: 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
, 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
.and so on and so forth...;
;
The tabs are no needed, I just put them there to make
[mailto:[EMAIL PROTECTED]]
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
.and so on and so forth...;
;
The tabs
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 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 also set to
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
24 matches
Mail list logo
