这样是不行的,可我找不到其它方法。 set sql_stat=concat('declare temp cursor for select from ',tablename); set @s:=sql_stat; prepare str from @s; execute str; 这样也不行,求帮助 !谢谢
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使用不正常,版本问题.
这样是不行的,可我找不到其它方法。
set sql_stat=concat('declare temp cursor for select from ',tablename);
set @s:=sql_stat;
prepare str from @s;
execute str;
这样也不行,求帮助 !谢谢
PREPARE A FROM @RUNSQL;
EXECUTE A;
DEALLOCATE PREPARE A;
象我这样写,给分吧
begin
SET @test=CONCAT('select * from',?);
PREPARE tt from @test;
set @tableName=tablename;
execute tt using @tableName;
end;在mysql5.2使用正常,mysql5.0.2使用不正常,版本问题.