A success response contains an activity count that indicates the total number of rows involved in the result.
For example, the activity count for a SELECT statement is the total number of rows selected for the response. For a SELECT, CALL (when the stored procedure or external stored procedure creates result sets), COMMENT, or ECHO statement, the activity count is followed by the data that completes the response.
An activity count is meaningful for statements that return a result set, for example:
For other SQL statements, activity count is meaningless.
The following interactive SELECT statement returns the successful response message.
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.