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

Expand|Select|Wrap|Line Numbers

 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.

how to set result of prepare stmt (MYSQL)

re: how to set result of prepare stmt (MYSQL)

re: how to set result of prepare stmt (MYSQL)

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about