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