Hi Gurhan,
Actually, the "source" command is what I was looking for. Thanks. I looked
through the documentation but for some reason could not find it.
- Neal
Gurhan Ozen <[EMAIL PROTECTED]> on 04/16/2002 03:43:42 PM
To: Neal Caidin <[EMAIL PROTECTED]>,
[EMAIL PROTECTED]
cc:
Subject: RE: Saving and re-using SQL statements
Hi Neal,
I am not clearly understanding your question , do you mean that you have
some variables in your queries??
Normally you would just save your query in a file and either run it in
the shell command line in batch mode with '<' operator or would just call
it
in mysql shell with 'source' syntax. But it sounds like you have some other
issues, can u please shed more light on the problem you are having?
In the meantime take a look at: http://www.mysql.com/doc/m/y/mysql.html
and
http://www.mysql.com/doc/B/a/Batch_mode.html
Gurhan
-----Original Message-----
From: Neal Caidin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 16, 2002 3:14 PM
To: [EMAIL PROTECTED]
Subject: Saving and re-using SQL statements
Hi All,
I am a little more familiar with Oracle environments where I can "save" and
"get" SQL statements that I formulate. How do I do this from within MySQL?
I've tried editing my query, with vi, and then saving it using vi's w
filename command, but I can't figure out how to restore the query. I use
vi's e filename to get the file, but then when I :wq out of vi it restores
the previous SQL statement I had input before grabbing the file with the e
option.
Thanks,
Neal
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php