Reset to default
Trending sort is based off of the default sorting method — by highest score — but it boosts votes that have happened recently, helping to surface more up-to-date answers.
It falls back to sorting by highest score if no posts are trending.
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.
Not 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