MySQL stored procedure: Provides query statements and returns the number of rows affected by query execution

MySQL Stored procedure: Provides query statements and returns the number of rows affected by query execution
DELIMITER $$DROP PROCEDURE IF EXISTS' P_get_select_row_number ' $$CREATE    PROCEDURE' test_cases '. ' P_get_select_row_number ' (inchP_select_sqlVARCHAR( $), Out P_countINT(8) )    BEGIN     --Statement    DECLARECntINT DEFAULT 0; DECLAREstmtVARCHAR( $); --Assign Value    SET @stmt =CONCAT (P_select_sql); --Prepare    PREPARES1 from @stmt; --Execution    EXECUTES1; --gets the number of rows affected by the query    SET @cnt =found_rows (); --Output Impact function    SELECT @cnt  intoP_count; END$ $DELIMITER; Call P_get_select_row_number ('SELECT * from Report',@qqq);SELECT @qqq;

Execution results

8 rows in Set (0.00 sec)

Query OK, 1 row affected (0.05 sec)

Mysql> SELECT @qqq;
+------+
| @qqq |
+------+
| 8 |
+------+
1 row in Set (0.00 sec)

MySQL stored procedure: Provides query statements and returns the number of rows affected by query execution