CODEWITHSUNDEEP
mysqlstored-proceduresprepared-statementprocedure
user1759270
user1759270

Reputation: 13

MySQL: count number of rows returned by a procedure

I want to Insert the records returned by procedure in to temporary table in another procedure

I have a Procedure Like Below


    call getName()

Now I want to Check whether the above procedure is returning records or not.

I want to do this in another procedure. So I am trying to insert the records returned from getName() procedure in to temp table in another procedure to carry out count operation.

Let me know how to count no of rows returned by one procedure in another procedure.

Upvotes: 1

Views: 978

Answers (1)

ethrbunny
ethrbunny

Reputation: 10469

  • Could you let me know how to insert values into temp table from stored procedure in Mysql

    create temporary table <name> select * from <some results>

  • Let me know how to count no of rows returned by one procedure in another procedure.

    select count(*) from <name>

Upvotes: 1

Related Questions