MySQL: how to get data about the results of execution with a remote query as with a local query?

Question

linux

When a query is executed locally, mysql reports the number of rows modified, execution time, and so on after execution.

mysql> update testtable set comment='comment_new' where comment='comment_1';
Query OK, 1 row affected (0.03 sec)
Rows matched: 1 Changed: 1 Warnings: 0

If you execute the request remotely

mysql --user username --password paswd -h 192.168.xx --database testdb -e "update testtable set comment='comment_new' where comment='comment_1';"

then if the query succeeds, the output will be empty.
Accordingly, the question is: how to get data on the number of affected rows and query execution time during remote execution?

Answer 1

Look aside - mysqli_affected_rows (mysql_affected_rows, PDOStatement::rowCount)