How to log SQL batch queries in a file

Question

Let's say I run a query in MySQL

mysql> delete from subscriber where mobile in (9899347241); Query OK, 2 rows affected, 18 warnings (32.91 sec)

So now I have a abc.sql which contains no. of such delete, update sql's and I run it using

mysql -h host -u user -p < abc.sql > output.txt

I have tried different options like --verbose, --tee. None seems to log the info text Query OK, 2 rows affected, 18 warnings (32.91 sec)

How can i log this. Basically when I have run the batch file, I want to be able to see if each query ran ok. One way for me to do this is to include a select query before and after the delete/update but there must be a better way to see if queries ran successfully.

Could be writing those messages to STDERR instead of STDOUT. Try adding 2>&1 to redirect stderr so it can be captured. — Marc B
– Marc B, Commented Mar 1, 2012 at 17:45

Emmanuel VOET · Accepted Answer · 2012-04-25 18:39:08Z

7

-vvv is the solution to what we are looking for.

answered Apr 25, 2012 at 18:39

Emmanuel VOET

862 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

RS3 · Accepted Answer · 2012-03-01 18:28:13Z

-1

2>&1 is what you are looking for

answered Mar 1, 2012 at 18:28

RS3

1941 gold badge3 silver badges15 bronze badges

Collectives™ on Stack Overflow

How to log SQL batch queries in a file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related