How to get number of rows affected, while executing MySQL query from bash?

Question

I know how one can execute MySQL queries / commands from bash:

mysql -u[user] -p[pass] -e "[mysql commands]" 

or

mysql -u[user] -p[pass] `<<`QUERY_INPUT  [mysql commands]  QUERY_INPUT 

How can I capture how many rows were affected by the query?
I tried doing:

variable='`mysql -u[user] -p[pass] -e "[mysql commands]"`' 

It does execute the command but it does not return the number of affected rows.

Answer 1

Put

SELECT ROW_COUNT(); 

as the last statement in your batch and parse the output