Stewart,
> All you should have to do is wrap the statement in () like:
> UPDATE SET field=(field+1) WHERE
I had a look in the manual (http://www.mysql.com/doc/U/P/UPDATE.html).
Where did you find the requirement for parentheses?
Do you have live code where UPDATE works with parentheses, but
<[EMAIL PROTECTED]>
> To: "Tyler Longren" <[EMAIL PROTECTED]>; "DL Neil"
> <[EMAIL PROTECTED]>
> Cc: "MySQL List" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 26, 2002 5:56 PM
> Subject: Re: "SET field=field+1" no longer works?
&g
I no longer have the original post in my inbox, I had a problem with
fetchmail which downloaded all the messages a couple hundred times, so i
did a mass delete.
All you should have to do is wrap the statement in () like:
UPDATE SET field=(field+1) WHERE
This will work fine from PHP using s
your help!
tyler
- Original Message -
From: "Stewart Gateley" <[EMAIL PROTECTED]>
To: "Tyler Longren" <[EMAIL PROTECTED]>; "DL Neil"
<[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, February 26, 2002 5:5
> executed properly. It only works correctly when issuing the query
> from the
> mysql command line client. :)
>
> Tyler
>
> - Original Message -
> From: "DL Neil" <[EMAIL PROTECTED]>
> To: "Tyler Longren" <[EMAIL PROTECTED]>
> Cc: &
uary 26, 2002 5:19 PM
Subject: RE: "SET field=field+1" no longer works?
> Have privileges changed?
>
> Dan
>
> > -Original Message-
> > From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, 27 February 2002 11:55 a.m.
> > To: DL Ne
Have privileges changed?
Dan
> -Original Message-
> From: Tyler Longren [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 27 February 2002 11:55 a.m.
> To: DL Neil
> Cc: MySQL List
> Subject: Re: "SET field=field+1" no longer works?
>
>
> Well, he
;t get
executed properly. It only works correctly when issuing the query from the
mysql command line client. :)
Tyler
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "Tyler Longren" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, Febr
Hi Tyler,
[back on-list so that others can offer their wisdom!]
OK, so it's not a problem with the MySQL client, then it's likely the PHP. Most likely
that the username and
password data values are strings and need to be properly contained with single- or
double-quotation marks.
If you need fu
Hello Tyler,
Did someone pick up this question - haven't spotted a response on the list?
I haven't spotted any such mis-behavior under either Win2000 or WinNT.
Are you entering the query at the command line or into some tool?
Have you tried another client?
If it is still unresolved, send me (NO
10 matches
Mail list logo