Re: Date Range

2004-09-27 Thread Dirk Bremer \(NISC\)
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

Re: Date Range

2004-09-27 Thread Dirk Bremer \(NISC\)
- 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

Re: Date Range

2004-09-27 Thread Dirk Bremer \(NISC\)
- 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

Re: Brainstorming' time!

2004-08-20 Thread Dirk Bremer \(NISC\)
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

Server Down/General Server Questions

2004-06-24 Thread Dirk Bremer \(NISC\)
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

Date/Time Difference Calculations

2004-06-11 Thread Dirk Bremer \(NISC\)
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

Re: Date/Time Difference Calculations

2004-06-11 Thread Dirk Bremer \(NISC\)
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

Re: Date/Time Difference Calculations

2004-06-11 Thread Dirk Bremer \(NISC\)
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

Re: Date/Time Difference Calculations

2004-06-11 Thread Dirk Bremer \(NISC\)
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

Re: Date/Time Difference Calculations

2004-06-11 Thread Dirk Bremer \(NISC\)
] 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

ORDER BY Question

2004-05-12 Thread Dirk Bremer \(NISC\)
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

Re: ORDER BY Question

2004-05-12 Thread Dirk Bremer \(NISC\)
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

Re: MySql Client Program Questions

2004-04-21 Thread Dirk Bremer \(NISC\)
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

MySql Client Program Questions

2004-04-20 Thread Dirk Bremer \(NISC\)
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

SQL Query Question

2004-04-16 Thread Dirk Bremer \(NISC\)
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

Re: SQL Query Question

2004-04-16 Thread Dirk Bremer \(NISC\)
- 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

Re: SQL Query Question

2004-04-16 Thread Dirk Bremer \(NISC\)
- 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