Re: Simple Question: MySQL and Shell Scripts

2003-06-24 Thread Don Read
On 24-Jun-2003 Fred Whipple wrote: > Don't forget to use '-B' in order to make the output silent except for > the results: > and -N to suppress column names. > 2. you should stick your password (which shouldn't match > your UNIX password) in a textfile readable only by you so that

Re: Simple Question: MySQL and Shell Scripts

2003-06-24 Thread Fred Whipple
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 mor

Re: Simple Question: MySQL and Shell Scripts

2003-06-24 Thread Paul Chvostek
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

Re: Simple Question: MySQL and Shell Scripts

2003-06-24 Thread Joseph Bueno
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: myva