No, the system command is part of the mysql interpreter, do a \h and see if it's listed, if it isn't then there is only one other way to do it. Split your sql script up into several pieces and have a shell script call it like this: mysql script1.sql echo here's some output mysql script2.sql echo here's some more output etc...
On Mon, 18 Oct 2004 21:19:13 -0400, Rhino <[EMAIL PROTECTED]> wrote: > I got basically the same error: > > sh: line 1: echo Hi there: command not found > > I know that echo works; I can do: > > echo "Hello" > > or > > echo 'Hello' > > on the command line and the result is Hello. > > However, when I do this on a command line: > > system > > I get: > > -bash: system: command not found > > The problem seems to be that I don't have the system command on my Linux > system. Is that normal for Mandrake 9.1? If it is, where do I get this > command? I can get the system administrator to install the appropriate RPM > if you can tell me what it is and where I can find it. > > Rhino > > > > ----- Original Message ----- > From: "Brian" <[EMAIL PROTECTED]> > To: "Rhino" <[EMAIL PROTECTED]> > Cc: "Logan, David (SST - Adelaide)" <[EMAIL PROTECTED]>; "mysql" > <[EMAIL PROTECTED]> > Sent: Monday, October 18, 2004 9:09 PM > Subject: Re: Script question > > > 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]
