Hello all,
I have a query that for some reason is now returning the incorrect year. First here is
my server configuration.
Windows 2003 Advanced server
MySQL version 4.0.15-nt
Here is my SQL statement:
SELECT
DATE_FORMAT(E.DateTime, '%X-%m-%d %h:%i:%s %p' ) AS DateTime,
E.SendCount AS
I just saw thay in the online documentation. Sometimes it help to read the manual
before posting.
Sorry.
[EMAIL PROTECTED] wrote:
Try %Y instead of %X
-Original Message-
From: PAUL MENARD [mailto:[EMAIL PROTECTED]
Sent: Monday, January 05, 2004 10:08 AM
To: [EMAIL PROTECTED]
Subject
Hello All,
I have two system, we shall call then system A (OLD) and system B (NEW), running
MySQL that I want to combine their tables. The system B is the newer and most
accurate. The table structure is the exact same. Some of the rows in system B (NEW)
tables are also in system A (OLD). For
Hello All,
I'm having trouble understanding the MySQL docs on how to subtract two DATETIME
values. I have two tables that have a DATETIME column. In my SELECT I am doing a JOIN
to bring in both sets of rows. What I want is to subtract the DATETIME values to
determine the number of seconds
Good morning all,
I have a problem with inceasing connection to my database that eventually result in
connections being rejected. I know I have an application that is terminating a thread
without closing the database handle. Problem is I'm waiting for the fix on some other
changes.
Here
PROTECTED] wrote:
Kill them :)
http://www.mysql.com/doc/en/KILL.html
Cheers
/rudy
-Original Message-
From: PAUL MENARD [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 16:44
To: [EMAIL PROTECTED]
Subject: How to terminate dead connections that are in SLEEP?
Good morning all,
I have
comment #2 below. Can anyone here explain this. I do
NOT wish to start using ODBC.
Im going to panic now.
On Wed, 2003-06-25 at 03:50, Paul Menard wrote:
I've been considering upgrading my data , MySQL
3.23.42 to 4.013 or even going to 4.1. I've read on
the MySQL upgrade documents that some
Hello All,
I'm having an intermittent problem with a MySQL server that I have running on a
Windows 2000 Advance server systems. This issue occurs every few days depending on the
load of the system.
Here are the details.
MySQL version 3.23.42-nt (I know I need to upgrade. Soon).
Machine:
Funny. I was just readin about this on the www.mysql.com web site. Under the
documentation section about upgrading form 3.23 to 4.0. The exact URL is
http://www.mysql.com/doc/en/Upgrading-from-3.23.html
Ensure that you don't have any MySQL clients that use shared libraries (like the Perl
Can anyone either summarize for me a comparison between the MyISAM and InnoDB MySQL
table type?
I am getting ready to upgrade from MySQL 3.23.42 to 4.0.13 in the coming week and
started reading the upgrade documents on the www.mysql.com site. Never had even
thought about using another table
,
Paul
-Original Message-
From: Boyd Lynn Gerber [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 5:50 PM
To: F. Paul Menard
Cc: [EMAIL PROTECTED]
Subject: Re: SCO and getrusage()
Paul,
I am not sure, but I think this is coming up because you need to use gcc
libraries. I seem
the program compiled!
Does anyone out there know where 'getrusage' lives. I see a reference to the
function in my /usr/include/sys/resources.h header but man show nothing. I
have also post a request to SCO about their libraries.
Any information/direction would be greatly appreciated.
Thanks,
Paul Menard
12 matches
Mail list logo