It would be beneficial to the group if everyone would post their solutions to the list
if they solve it on their own.
IMHO,
Mark
-Original Message-
From: Ken Kinder [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 16, 2001 10:10 AM
To: Walter D. Funk; [EMAIL PROTECTED]
Subject: Re:
next function which was
my demise.
>SELECT UserId, SUM((UNIX_TIMESTAMP(LogoutDate) -
> UNIX_TIMESTAMP(LoginDate))) / 3600
> AS secs FROM tbl_name GROUP BY UserId;
Works great.
Mark Rissmann
At 4:21 PM -0800 11/25/01, Mark Rissmann wrote:
>>Thanks Mr. DuBois,
>>
>>I must h
query that will calculate the hours worked for each
record and then sum them up?
This is going directly to a report engine so I have little control over
it (like running multiple queries) except I am able to manipulate the
final value and format it.
Thanks for any help.
Mark Rissmann
by php
via the internet. The databases will be about 400mb estimated for the first
year.
Any recommendations or info would be greatly appreciated. (Or things NOT to
do) :)
Mark Rissmann
Drifting Sands LLC
- Original Message -
From: "Mike Rogers" <[EMAIL PROTECTED]>
Sent:
p give them incentive to continue. ;)
Mark Rissmann
Drifting Sands LLC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
ecognize a
> >group of inserts into a table and queue them. This should be faster.
You'll
> >have to experiment on how long you allow the queue to build.
> >
> >Disable or remove indexes. This sometimes speeds it up tremendously
> >depending on your indexes.
>
