Hi all,
I'm trying to work out the difference in a field between the last 2
updates in an updates table. I'm doing this as shown below:
mysqlSELECT
- (@in - AcctInputOctets) AS AcctInputOctets,
- (@out - AcctOutputOctets) AS AcctOutputOctets,
- (@in :=
On Fri, Oct 17, 2008 at 2:12 AM, Ian Christian [EMAIL PROTECTED] wrote:
Hi all,
I'm trying to work out the difference in a field between the last 2
updates in an updates table. I'm doing this as shown below:
mysqlSELECT
- (@in - AcctInputOctets) AS AcctInputOctets,
-
On Fri, Oct 17, 2008 at 9:56 AM, Rob Wultsch [EMAIL PROTECTED] wrote:
On Fri, Oct 17, 2008 at 2:12 AM, Ian Christian [EMAIL PROTECTED]wrote:
Hi all,
I'm trying to work out the difference in a field between the last 2
updates in an updates table. I'm doing this as shown below:
mysql
2008/10/17 Rob Wultsch [EMAIL PROTECTED]:
*How long does the second query actually take to run compared to first?
Actually, really quickly - so quickly that I also suspected that a
full table scan was not taking place. I'd like to understand how the
output of EXPLAIN can differ from the
On Fri, Oct 17, 2008 at 10:31 AM, Ian Christian [EMAIL PROTECTED] wrote:
2008/10/17 Rob Wultsch [EMAIL PROTECTED]:
*How long does the second query actually take to run compared to first?
Actually, really quickly - so quickly that I also suspected that a
full table scan was not taking
Why are you creating a subquery/derived table?
Just change your limit to 1,2
ORDER BY updates.AcctSessionTime DESC LIMIT 1,2
Like you did in the outer query.
Brent
On Fri, Oct 17, 2008 at 5:12 AM, Ian Christian [EMAIL PROTECTED] wrote:
Hi all,
I'm trying to work out the difference in a
2008/10/17 Brent Baisley [EMAIL PROTECTED]:
Why are you creating a subquery/derived table?
Just change your limit to 1,2
ORDER BY updates.AcctSessionTime DESC LIMIT 1,2
Because then the maths in the select part isn't executed, and I don't
get the figures I need.
--
MySQL General Mailing