How get a mysql shell response in a script.
 

Hello,

I'm doing a script for an automatic logging in MYSQL and I would like to analyse the reply to know if loging was succesfull or not.
I tried a lot of thing, but nothing work

szReply=mysql -u root -ppassword database
mysql -u root -ppassword database>szReply
mysql -u root -ppassword database|mysql -u root -ppassword database

How can I do to get the response in szReply or put it in a file.

Thanks in advance.

I'm not sure if it will help your logging, because as far as I know, executing sql on the command line only outputs errors to the shell, not anything else. But this is what I would do:

cat sqlcommands.sql | mysql -u you -p pw database > output.log 2>&1

where your commands are in sqlcommands.sql

Thanks a lot, this really help me, but I have one more question.

Why this line is working:
mysql -u you -p pw database > output.log 2>&1
and not
mysql -u you -p pw database > output.log
The second line is not working?? where is the difference?

Thanks.

'2>&1' redirects the standard error stream (2) to the standard output stream (1).

Are you working with it interactively? How on earth can you tell what's going on if you capture all the console output?!