Sorry, you still haven't got it;-)

I want the echo command to be in the *script*, not to be supplied at the
command line. Is there some way to put a mix of MySQL commands and OS
commands into a script and have both executed successfully via:

mysql -u myid -pmypass < Load.sql > Load.out

Rhino


----- Original Message ----- 
From: "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
Sent: Monday, October 18, 2004 8:09 PM
Subject: RE: Script question


After re-reading your email in not so quite a rush 8-)

Further to that, you can use the system command to run an OS command

eg. system "echo thing";

mysql> system echo "thing";
thing
mysql>



Regards

David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia

+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax



________________________________

From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 19 October 2004 9:13 AM
To: mysql
Subject: Script question



Can anyone tell me how to make a script containing MySQL commands also
execute an OS command?

For instance, given this script, called Load.sql:

--------------
use SFL;

#Load the data from the export file that was exported from Q&A as a
standard
#ASCII file.
load data infile '/home/rhino/MySQL/SFL/FILMS.AS3'
replace into table Dougs_Movies
fields terminated by ';'
optionally enclosed by '"'
escaped by '\\'
lines starting by '"'
terminated by '\r\n';

----------------

I'd like to add some 'echo' statements to the script. However, when I
include:

echo "Hello"

or

!echo "Hello"

I get a syntax error when I execute the script.

I am executing the script from the Linux command line via this command:

mysql -u myid -pmypass < Load.sql > Load.out

It isn't strictly necessary to include 'echo' commands in the script as
long as I can ensure that the text of my choice appears in the Load.out
file in the place of my choosing, i.e. after the 'use' command has been
executed but before the 'load' command has been executed.

Can anyone help me this problem? I can't believe it is hard but I can't
think what to search on in the archives.....

Rhino
---
rhino1 AT sympatico DOT ca
"There are two ways of constructing a software design. One way is to
make it so simple that there are obviously no deficiencies. And the
other way is to make it so complicated that there are no obvious
deficiencies." - C.A.R. Hoare


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to