I've never noticed anything like a BEEP command in MySQL but I've never
looked either :-)
If you don't find a facility like that in MySQL, may I suggest an
alternative that will give you more than a mere Beep: it will play any .wav
file you like.
I use Ant for most of my scripting needs. You may not be familiar with Ant
so here is a link to its home page: http://ant.apache.org/. You can access
the manual for the current version of Ant on this page. One of the many
optional tasks within Ant is the 'sound' task. It is capable of playing one
sound file if a script fails and a different one if a script succeeds. Or,
if you like, it will choose one sound file at random from an entire
directory if a script fails and one sound file from an entire directory if a
script succeeds.
I've taken advantage of this to write a bit of common code that goes into
all of my Ant scripts. The code identifies the directory that contains my
'success' files and the directory that contains my 'failure' files. If the
script succeeds, one of the files in the 'success' directory is played and
if the script fails, one of the files in the 'fail' directory is played.
Just for the fun of it, my 'success' and 'failure' files are all fragments
from famous movies or TV programs. For instance, I have 'failure' files for
the robot on Lost in Space saying "That does not compute!" or Homer Simpson
saying "D'oh!" and I have similar 'success' files that have a more positive
message.
Of course, this is approach is excessive if you really just want a Beep
sound! My suggestion won't even be practical for you if you don't have a
sound card in your computer.
However, if you do have a sound card and don't mind using it for something
like this, you can use this approach to play an appropriate audio file
whether the script succeeds or fails. You also get the huge added bonus of
being able to use Ant for your scripts! And, depending on what sound files
you select for your 'success' and 'failure' folders, you can entertain
yourself and the others around you when your scripts run; one of my friends
howled in laughter when he heard the sound file I played at the completion
of one of my scripts. :-)
[Sorry for top-posting; I was going to intersperse my reply but my email
client (Outlook Express) isn't marking your remarks with > the way it
should.]
----- Original Message -----
From: "C.R.Vegelin" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Friday, December 16, 2005 9:23 AM
Subject: is there any BEEP command ?
I use various script files with queries to update a MySQL base periodically.
These scripts are run from the mysql> line with the \. command.
I would like to have a BEEP command at the end of the script to get a signal
that processing the script is finished. Looked in the manual, but couldn't
find it. Does such a command exist ?
My version is 5.0.15 under Windows XP Pro.
Regards, Cor
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.1/204 - Release Date: 15/12/2005
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.1/204 - Release Date: 15/12/2005
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
