how to set result of prepare stmt (MYSQL)

[pankaj17]

hello everyone,

MYSQL query ............

how to set prepare stmt result in variable

i have written prepare stmt in store procedure and i want to set result of prepare stmt in variable

CREATE PROCEDURE `sp_countrows`(in_table_name varchar(30))
READS SQL DATA
BEGIN
SET @s = CONCAT('SELECT sum(QuotaUsage) AS "', in_table_name, '(SUM)" FROM ', in_table_name);
PREPARE stmt FROM @s;
EXECUTE stmt;
END

[Atli]

So you want to use the results of the query in the procedure?

If so, you should look into Cursors.

[pankaj17]

can u explain me with example. I haven't used the cursor yet.
I am new in mysql.
so please tell me with example how to get the prepare stmt result using cursor........

I have seen example of cursor in mysql site. but they haven't used the prepare stmt.

i am passing table name as a parameter to procedure because the tables are generated dynamically after every month (that kind of script is written on linux OS). so the table name is not fix.