Zach wrote:
I am writing a shell script using Born Shell. I am trying to get the
result of a SQL statement into a variable.
For example:
/usr/bin/mysql -uroot -prootpass BOB EOF
SELECT * FROM Bobstable WHERE Name=1
EOF
How do I get the result into a variable?
Thanks in advance!
May be:
On Mon, Jun 23, 2003 at 06:37:17PM -0500, Zach wrote:
I am writing a shell script using Born Shell. I am trying to get the result of a SQL
statement into a variable.
You mean Bourne shell.
For example:
/usr/bin/mysql -uroot -prootpass BOB EOF
SELECT * FROM Bobstable WHERE Name=1
EOF
Joseph Bueno wrote:
Zach wrote:
I am writing a shell script using Born Shell. I am trying to get the
result of a SQL statement into a variable.
For example:
/usr/bin/mysql -uroot -prootpass BOB EOF
SELECT * FROM Bobstable WHERE Name=1
EOF
How do I get the result into a variable?
But this is more
On 24-Jun-2003 Fred Whipple wrote:
snip
Don't forget to use '-B' in order to make the output silent except for
the results:
and -N to suppress column names.
snipagain
2. you should stick your password (which shouldn't match
your UNIX password) in a textfile readable only by you
I am writing a shell script using Born Shell. I am trying to get the result of a SQL
statement into a variable.
For example:
/usr/bin/mysql -uroot -prootpass BOB EOF
SELECT * FROM Bobstable WHERE Name=1
EOF
How do I get the result into a variable?
Thanks in advance!