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.
Put
SELECT ROW_COUNT();
as the last statement in your batch and parse the output
-s (silent) before the -e, as well as -N to remove the header row. You should get the actual numeric value only from this. See this: stackoverflow.com/questions/25539218/…Looking at the documentation, apparently using -v at least 3 times forces MySQL to be more verbose and it prints how many rows where affected. Example:
mysql -vvv ...
Reference:
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html#option_mysql_verbose
-vvv is great if you want more details, which includes query execution time.
-v and -vvv?v you add you get increased verbosity and more information (like query execution times, etc).vs. What about -vvv vs -v -v -v vs -v -vv vs -vv -v?
-vvNot an answer, but useful addition, you also could try the other MySQL information functions ( which include ROW_COUNT() ) to give you specific information you require. See MySQL reference here
