]
Subject: RE: Complex select statement
Still having a problem with this. Still have one last thing that isn't working. This
is MySQL 4.0.13.
UPDATE table_tmp,table2_daily SET table_tmp.period_count = table_tmp.count -
table2.count WHERE table_tmp.id = table2.id AND MAX(table2.timestamp);
ilto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 4:27 PM
To: [EMAIL PROTECTED]
Subject: Re: Complex select statement
As far as I know, MAX only returns the greatest row, so what you really
want at the end is
WHERE table_tmp.id=table2.id AND table2.timestamp=MAX(table2.timestamp)
~MJI
Roy W
As far as I know, MAX only returns the greatest row, so what you really
want at the end is
WHERE table_tmp.id=table2.id AND table2.timestamp=MAX(table2.timestamp)
~MJI
Roy Walker wrote:
Still having a problem with this. Still have one last thing that isn't working. This is MySQL 4.0.13.
UPDAT
ow to do it 4.1! Please! :)
Roy
-Original Message-
From: Rudy Metzger [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 3:49 AM
To: Roy Walker; [EMAIL PROTECTED]
Subject: RE: Complex select statement
I never heard before that you can use a select statement in an arithmetic expression.
Onl
ld also be the way how I would do it in a different DB (e.g. ORACLE).
Cheers
/rudy
-Original Message-
From: Roy Walker [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 18:30
To: [EMAIL PROTECTED]
Subject: RE: Complex select statement
Eva,
Thanx for your help. Still having an issue
st regards
Nils Valentin
Tokyo/Japan
>
> Thanx,
> Roy
>
> -Original Message-
> From: "Paracková Eva, Ing" [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 11, 2003 12:30 AM
> To: Roy Walker
> Subject: RE: Complex select statement
>
> try this:
>
>
ge-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 11:52 AM
To: [EMAIL PROTECTED]
Subject: Re: Complex select statement
"Roy Walker" <[EMAIL PROTECTED]> wrote:
>
> Thanx for your help. Still having an issue with this. I forgot to
ment
"Roy Walker" <[EMAIL PROTECTED]> wrote:
>
> Thanx for your help. Still having an issue with this. I forgot to mention I am
> running MySQL 4.0.13. Tried both of these statements:
>
> INSERT INTO table2 (id,count,period_count,date) SELECT id as id1, count, (count -
> (SELECT count FROM table2
for the 'SELECT count FROM table2 WHERE id=id1' section.
Is this illegal syntax? Would this be considered a subselect?
Thanx,
Roy
-Original Message-
From: "Paracková Eva, Ing" [mailto:[EMAIL PROTECTED]
Sent: Friday, July 11, 2003 12:30 AM
To: Roy Walker
Subject
