- Original Message -
From: David Souza [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 25, 2004 7:18 PM
Subject: Question about SQL statements..
So I have all of this years apache access logs in a huge DB table, most
of what I wanted to get out is working fine,
You rock!! Worked perfectly
On Aug 25, 2004, at 4:31 PM, Rhino wrote:
- Original Message -
From: David Souza [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 25, 2004 7:18 PM
Subject: Question about SQL statements..
So I have all of this years apache access logs in
From: Cory Hicks [mailto:[EMAIL PROTECTED]
Hello,
I must be having a goober moment.I am running the following sql
query with no problems:
SELECT project_id,
IF (SUM( time_worked ) '0.00', SUM( time_worked ),'NULL') AS total
FROM time_daily
WHERE user_id = 'clh' AND period_id =
Would something like this do what you want?
SELECT project_id, SUM(time_worked) AS total FROM time_daily WHERE
user_id='clh' AND period_id='27' GROUP BY project_id HAVING total0;
Cory Hicks wrote:
Hello,
I must be having a goober moment.I am running the following sql
query with no
Like this:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.13
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
umysql use test;
Reading table information for completion of table and column names
You can turn off this
That did the trickthanks so much!
Cory
On Wed, 2004-01-14 at 12:50, Douglas Sims wrote:
Would something like this do what you want?
SELECT project_id, SUM(time_worked) AS total FROM time_daily WHERE
user_id='clh' AND period_id='27' GROUP BY project_id HAVING total0;
Cory Hicks
At 07:55 AM 9/13/2001 -0500, Michael Sims wrote:
Hi,
I posted this query to the list via the newsgroup mailing.database.mysql a
few days ago but didn't receive any replies.
My apologies to the list...someone in alt.php was kind enough to point out
that my question is answered in section