dd and
> might explain some weird experiences.
>
>
> DVP
>
> Dathan Vance Pattishall
> http://www.friendster.com
>
>
> > -Original Message-
> > From: Monet [mailto:[EMAIL PROTECTED]
> > Sent: Monday, September 13, 2004 10:22 AM
> &g
Monet [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 13, 2004 10:22 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: IN operator
>
> Hi there,
> I used very likely statement last week to update one
> table. My IN value is around 20. I checked the manual
&
Hi there,
I used very likely statement last week to update one
table. My IN value is around 20. I checked the manual
and there is nothing about any limitation on IN
values.
However, when i was running it, it worked very well
sometimes, while sometimes, the query crashed in the
middle and i have to
Since you do not seem to have subqueries available to you (pre 4.1.x),
have you looked at modifying your queries to use JOINs, temp tables, or
both?
What is it you are trying to accomplish, we can help you to build the
appropriate statement(s). Optionally, you can upgrade to a version that
su
* Oliver Hirschi <[EMAIL PROTECTED]> [09/13/04]:
> Hi people
>
> Due to MySQL does not support "inner-selects", I generate a string (I
> programm java-client) with the values I used in an IN-operator for an
> update onto a mySQL database.
>
> The statement looks like this:
> UPDATE layer SET Stat
