Search Results

Sorry for the confusion, you are correct. Both of your replies have been added to my notes, and will are extremely useful. Thank you very much!

verdepolo, thanks for the reply. It seems to be working, but now I'm getting this message:

my script contains one line:
'show tables';I've tried it unquoted and double quoted too.
When I try...

Can someone tell me the syntax to run a shell script from within MySQL? I know there is a way to do it, but I can't remember the syntax. I thought it was something like:

mysql> \....

Thanks again, but I used your code, and it works perfectly on OS X!

Frans, thanks for the info. One quick question, though. How can I tell if I have GNU date? I'm running OS X 10.6.6.

I'm extracting two time & date values from a log file, and I need a way to calculate the elapsed time between the two. The values are in this format:

Feb 12 10:53:15
Feb 12 10:59:57

The...

i've been struggling with installing the Perl DBI & DBD modules all weekend, and I'm getting close, but no cigar as of yet. When I run the perl script db.pl I get the following mismatch error:
Mon...

I'm using the bash shell on a MacBook Pro running Snow Leopard 10.6.3. 99.9% of things work perfectly, but I'm having one problem using the #! syntax for executing Perl scripts. Some of my perl...