try: system "echo hi there"; without the single quotes :)
On Mon, 18 Oct 2004 21:04:19 -0400, Rhino <[EMAIL PROTECTED]> wrote: > I thought you'd nailed it when I read your note but I found that your > suggestion didn't work. > > When I tried executing the script with this added to it: > > system "echo 'hi there'"; > > I got this on the command line: > sh: line 1: echo 'hi there': command not found > > I tried doing a man system and got an article from the Linux Programmer's > Manual about a C function named system(). It's beginning to look like I > don't have the 'system' command on my server. I am not a strong Unix person; > should the 'system' command be there? I'm running Linux Mandrake 9.1. Maybe > 'system' is only available on some of the Unix platforms but not Mandrake > 9.1?? > > > > Rhino > > ----- Original Message ----- > From: "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]> > To: "Rhino" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]> > Sent: Monday, October 18, 2004 8:31 PM > Subject: RE: Script question > > The only way to mix and match with an .sql script would be to use the > system command. The example I showed below would echo the text required > and that would be diverted to Load.out file eg. > > -------------- > use SFL; > > system "echo 'my choice of text'"; > system "cat /etc/passwd"; > system "cat afilethathasmytextinit"; > > #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'; > > ---------------- > > When run as > > mysql -u myid -pmypass < Load.sql > Load.out > > All output (including that of the system commands) will be echoed into > the Load.out file > > Otherwise I'm confused as to what you are trying to do. Sorry 8-) > > 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 > > -----Original Message----- > From: Rhino [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 19 October 2004 9:53 AM > To: Logan, David (SST - Adelaide); mysql > Subject: Re: Script question > > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]