从bash执行MySQL查询时如何获取受影响的行数?

2021-11-20 00:00:00 bash mysql

我知道如何从 bash 执行 MySQL 查询/命令:

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.

推荐答案

Put

SELECT ROW_COUNT();

作为批处理中的最后一条语句并解析输出

as the last statement in your batch and parse the output

相关文章