I know how one can execute MySQL queries / commands from bash:
mysql -u[user] -p[pass] -e "[mysql commands]"
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.
as the last statement in your batch and parse the output
I might have answered myself the question, been looking at the parameters, and aparently using "-v -v -v" as parameters to the mysql command forces it to be more verbose and it spits out how many rows where affected.