Bob Ramsey <[EMAIL PROTECTED]> wrote:
>
> I'm using 3.23.51 and I'd like to update a field in a certain order. I've
> got a table of images for a slide show and the format of the table is:
>
> image varchar(128) not null
> order_number integer not null primary key
>
> So we might have somethin
Thanks for all your replies. I'll have to use the 2 query approach.
Regards
Martin
"Mike Hillyer" <[EMAIL PROTECTED]>
23/06/2003 23:22
To: <[EMAIL PROTECTED]>, "wayne" <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
> Sent: Monday, June 23, 2003 4:21 PM
> To: wayne
> Cc: [EMAIL PROTECTED]
> Subject: RE: UPDATE and ORDER BY
>
>
> Hi, I left out the LIMIT 1 in the example I copied... I only want the
> first occurance updated.
>
>
>
>
>
>
> "wayne&quo
Hi, I left out the LIMIT 1 in the example I copied... I only want the
first occurance updated.
"wayne" <[EMAIL PROTECTED]>
23/06/2003 23:22
To: <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
Subject: RE: UPDATE and ORDER BY
Have you tried it without it? I cannot seen a reason for using it...
With out it all records in subscriptions will be updated with pick+1
where username='webmaster' and dbname.
Wayne
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 23 June 2003 23:09
To: [E
At 23:09 +0100 6/23/03, [EMAIL PROTECTED] wrote:
Hi,
Any ideas why I get an error when i use ORDER BY in an UPDATE statement?
Also is there anywhere i can lookup the error codes?
UPDATE `Subscriptions` SET picks=picks+1 WHERE (username = 'webmaster' AND
picksdatabasename = 'BetaTestService') ORDER
Well, Jeff you are right! I've just taken the
wrong line from .mysql_history file. It was one
of my thousands of tries to make the ORDER BY work
with UPDATE. What I really try to do is ORDER BY
the 'received' column, which is a timestamp.
The point is if I have plenty of alarm messages
which are n
