Re: Script question

2004-10-20 Thread SGreen
Just so everyone is up to speed: The "system" client command is only available on Unix-like systems. To quote: http://dev.mysql.com/doc/mysql/en/mysql_Commands.html >>The edit, nopager, pager, and system commands work only in Unix. << So depending on your OS, that command may or may not be avai

Re: Script question

2004-10-19 Thread Gerald Taylor
Philippe Poelvoorde wrote: mysql> system echo hi there; mysql> system ls -ls; mysql> system uname-a; all work on the 2.4.22-10mdk kernel and the semi-colon is optional. mysql> system echo "hi there" should be also working, the first parameters 'echo' is recognized as the command to execute, and

Re: Script question

2004-10-19 Thread Philippe Poelvoorde
mysql> system echo hi there; mysql> system ls -ls; mysql> system uname-a; all work on the 2.4.22-10mdk kernel and the semi-colon is optional. mysql> system echo "hi there" should be also working, the first parameters 'echo' is recognized as the command to execute, and the folowings strings the

Re: Script question

2004-10-18 Thread Rhino
Thanks, Charles! Your suggestion about removing the quotes and apostrophes altogether did the trick! Rhino - Original Message - From: "Sweet, Charles E" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Monday, October 18, 2004 9:22 PM Subj

Re: Script question

2004-10-18 Thread Brian
ssage - > 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 > Su

RE: Script question

2004-10-18 Thread Sweet, Charles E
n; 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 -

Re: Script question

2004-10-18 Thread Rhino
o - 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: Scrip

Re: Script question

2004-10-18 Thread Brian
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

Re: Script question

2004-10-18 Thread Rhino
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]>; "

Re: Script question

2004-10-18 Thread Victor Pendleton
ave 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, O

RE: Script question

2004-10-18 Thread Logan, David (SST - Adelaide)
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 PR

Re: Script question

2004-10-18 Thread Rhino
.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

RE: Script question

2004-10-18 Thread Logan, David (SST - Adelaide)
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 5

RE: Script question

2004-10-18 Thread Logan, David (SST - Adelaide)
Hi Rhino, This works, however I can't remember how to suppress the column heading. If you can do that, you can put anything you like in. [EMAIL PROTECTED] loganda]$ echo "set @thing='here we go';select @thing"| mysql -u root -p >outfile Enter password: [EMAIL PROTECTED] loganda]$ cat outfile @t