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
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
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
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
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
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 -
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
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
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]>; "
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
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
.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
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
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
14 matches
Mail list logo
