oun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, 20 July 2012 1:56 AM
To: U2 Users
Subject: [U2] MySQL query qestion
This is specific to MySQL, but could apply to any SQL DB.
Is there a way to put the results of one query to be used by anot
2ug.org] On Behalf Of Wols Lists
Sent: Thursday, July 19, 2012 12:47 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] MySQL query qestion
My SQL-fu isn't up to much, but my reaction was along the lines of
SELECT *, LAST_UPDATED=GET_PROCEDURE() FROM TABLE WHERE LAST_UPDATE >
LAS
listserver.u2ug.org] On Behalf Of George Gallen
> Sent: 19 July 2012 16:56
> To: U2 Users
> Subject: [U2] MySQL query qestion
>
> This is specific to MySQL, but could apply to any SQL DB.
>
> Is there a way to put the results of one query to be used by another,
> withou
ailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: 19 July 2012 16:56
> To: U2 Users
> Subject: [U2] MySQL query qestion
>
> This is specific to MySQL, but could apply to any SQL DB.
>
> Is there a way to put the results of one query to be use
alf Of George Gallen
Sent: 19 July 2012 16:56
To: U2 Users
Subject: [U2] MySQL query qestion
This is specific to MySQL, but could apply to any SQL DB.
Is there a way to put the results of one query to be used by another,
without having that second query run on each Iteration of the sub qu
This is specific to MySQL, but could apply to any SQL DB.
Is there a way to put the results of one query to be used by another, without
having that second query run on each
Iteration of the sub query?
Example:
SELECT * FROM TABLE WHERE LAST_UPDATE > (SELECT UPDATE_PROCEDURE());
The function UP