RE: Project Time

2002-05-13 Thread Robert L. Yelvington
http://freshmeat.net Methinks this is what Jay meant! ;) ~Rob %-Original Message- %From: Steve Buehler [mailto:[EMAIL PROTECTED]] %Sent: Monday, May 13, 2002 2:44 PM %To: Jay Blanchard; [EMAIL PROTECTED] %Subject: RE: Project Time % % %Do you know if freshmeat is only online certain ti

need SQL assistance with a few selects

2002-05-03 Thread Robert L. Yelvington
Greetings folks, I am able to do all this by pulling out data with PHP or PERL...just need some straight MySQL command line advise Specifically, I need some assistance with the following: Here's my table's structure (table name is 'table'): ID, CLIENT_NAME, CLIENT_LOGIN, DISK_SIZE, RUNTIME

RE: check for server start

2002-01-11 Thread Robert L. Yelvington
a quick fix would be to see if the default port is open or not...something like: netstat -an | grep "3306" you could put that in a shell script and do all sorts of tests against it. -OR- you could use mysqladmin and whatever flag used to check status. hope this helps. ~rob -Original Mes

RE: DATES & Optimization

2002-01-11 Thread Robert L. Yelvington
Thanks, Paul. ;) ~rob > -Original Message- > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 09, 2002 8:22 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: DATES & Optimization > > > At 9:02 -0600 1/9/02, Robert L. Yelvin

DATES & Optimization

2002-01-09 Thread Robert L. Yelvington
Two quick qux for the gurus on the list! 1. If I needed to do date calculations based upon a TIME STAMP field, what's the most efficient way to accomplish this with respect to data types (field types...I already understand how to use the DATE functions and am aware of locale time and UNIX time tr

RE: mysql_install_db problem

2002-01-07 Thread Robert L. Yelvington
Have you verified that the mysql internal data bases don't exist? If you are running a Win binary, they should already exist. I don't even think mysql_install_db is part of the Win dist. It is a shell script used in UNIX installations. ~rob Sent: Monday, January 07, 2002 11:38 AM To: [EMAIL