Re: help with procedure and tablename

[Roland Bouman]

Why? Jay's sugggestion is totally correct, use the PREPARE syntax. This should work fine:

drop procedure curdemo;
delimiter //
CREATE PROCEDURE curdemo()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE id_memberx int (16);
DECLARE tabla int (3);
DECLARE cur1 CURSOR FOR SELECT `ID_MEMBER`,FLOOR(`ID_MEMBER`/10000) FROM `yabbse_members` ORDER BY `memberName` LIMIT 100;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;

OPEN cur1;

myloop: LOOP
FETCH cur1 INTO id_memberx,tabla;
if done = 1 then
leave myloop;
end if;
SELECT memberName FROM `yabbse_members` WHERE `ID_MEMBER`=id_memberx;
SELECT id_memberx,CONCAT('tabla ',tabla);

@stmt := concat(
'INSERT INTO '
, cur1.tabla
, ' SELECT * FROM `yabbse_members` WHERE `ID_MEMBER`=id_memberx'
)
PREPARE stmt FROM @stmt;
EXECUTE stmt;
DEALLOCATE stmt;

end loop;

CLOSE cur1;
END
//
delimiter ;