Whether he needs semicolons depends on which tool he is using to execute
his statements. If he is using the MySQL client or any of several other
tools, I agree. If he is going through an ODBC connection, he doesn't need
them. (At least my 3.52.x drivers can't accept more than one statement per
- Original Message -
From: [EMAIL PROTECTED]
To: Dirk Bremer (NISC) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 27, 2004 11:40
Subject: Re: Date Range
To compute the date range for two months ago. (if the current month is
September, this will return July's data
- Original Message -
From: [EMAIL PROTECTED]
To: Dirk Bremer (NISC) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, September 27, 2004 14:30
Subject: Re: Date Range
I think you are very close but you are missing the LAST day of each month.
I think you need to change your WHERE
Note that based upon this thread, I downloaded and installed MyODBC (simple
Google search), configured a DSN, created an Excel query, and loaded the DB
into the worksheet in under 5-minutes total time. While I don't use Excel
that much for anything, it was a very simple exercise and might prove
I had an interesting situation to deal with this morning. The server that
runs our production version of MySQL crashed with some type of kernel error
(Win2K). When the server was brought back up, MySQL which runs as a service
was not running when I checked on it this morning. I could not restart
I'm using MySQL version 4.0.18. I have two datetime columns in the same
table, one that represents a start time and the other that represents an end
time. I would like to write a query that will show the difference between
these two columns in a HH:MM:SS format. The values of the two columns as
Eamon Daly
- Original Message -
From: Dirk Bremer (NISC) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 11, 2004 1:57 PM
Subject: Date/Time Difference Calculations
I'm using MySQL version 4.0.18. I have two datetime columns in the same
table, one
Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
www.nisc.cc
- Original Message -
From: Dirk Bremer (NISC) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 11, 2004 14:29
Subject: Re: Date/Time Difference Calculations
Here is an example using sec_to_time. Note
Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
www.nisc.cc
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Dirk Bremer (NISC) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, June
]
www.nisc.cc
- Original Message -
From: [EMAIL PROTECTED]
To: Dirk Bremer (NISC) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, June 11, 2004 14:54
Subject: Re: Date/Time Difference Calculations
I didn't see where these were 4.1+ function so I think it will work. I
refer you
The following query produces the following results:
select job_coop as 'Job/Coop', count(*) as Count from queue group by
job_coop;
+--+---+
| Job/Coop | Count |
+--+---+
| B03013 |19 |
| B05044 | 9 |
| B07037 | 6 |
| B15037 | 4 |
| B16032 | 6
select job_coop as 'Job/Coop', count(*) as Count from queue group by
job_coop order by Count;
The other alternative is to omit the 'as Count' and use this query:
select job_coop as 'Job/Coop', count(*)
from queue
group by job_coop
order by 2;
where the '2' in the 'order by' is the
At 16:03 -0500 4/20/04, Dirk Bremer (NISC) wrote:
I have a couple of questions concerning the MySql client program.
1. Are the option for the client program, i.e. --auto-rehash, etc.
documented anywhere? I searched the included HTML file and could not find
a
reference to the client options
I have a couple of questions concerning the MySql client program.
1. Are the option for the client program, i.e. --auto-rehash, etc.
documented anywhere? I searched the included HTML file and could not find a
reference to the client options. What does the --auto-rehash option do?
Heck, what do
I have a simple table where one of the columns is named queue_time and is
defined as a timestamp-type. I would like to query this table for all rows
where the queue_time equals the current date. I an a newbie and have been
wrestling with the docs for a solution. You help will be appreciated.
Dirk
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'Dirk Bremer (NISC) ' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, April 16, 2004 15:06
Subject: RE: SQL Query Question
WHERE queue_time = Now() + 0
Are you wanting just the date or the datetime?
-Original
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'Dirk Bremer (NISC) ' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, April 16, 2004 15:57
Subject: RE: SQL Query Question
If your data is stored in the following format
2004-04-16 00:00:00
you can do WHERE
17 matches
Mail list logo