MYSQL 存储过程内用存储过程的参数作表名查找
create procedure test(in tablename varchar(10))
begin
declare temp cursor for select * from tablename ;
open temp;
....
end temp;
end
[解决办法]
set sql_stat=concat( 'declare temp cursor for select from ',tablename);
SET @RUNSQL = sql_stat;
PREPARE A FROM @RUNSQL;
EXECUTE A;
DEALLOCATE PREPARE A;
象我这样写,给分吧
[解决办法]
create procedure pg_proc()
begin
SET @test=CONCAT('select * from',?);
PREPARE tt from @test;
set @tableName=tablename;
execute tt using @tableName;
end;
在mysql5.2使用正常,mysql5.0.2使用不正常，版本问题.
