MySQL Forums
Forum List  »  Newbie

Storing data in variables from "\!" or system command.
Posted by: Ben Kirby
Date: July 10, 2005 04:39PM

I am trying to get the results from a unix command stored into a field or user variable.
I am using the new in version 4 system of \! command.

Something like this.

mysql> set @pass = \! ~/setpasswd testing ;

But it just returns the value to the screen and does not store it in the variable.
$1$Q4c8v6rK$hmVLelRR/j6Pabpw2ILUy.

The setpasswd script is just a csh script that says
openssl passwd -1 $1

Which take input in this case the string "testing" and returns a unix crypt_MD5 salted password.

Any help would be greatly appreciated.

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Storing data in variables from "\!" or system command.
July 10, 2005 04:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.