56,912
社区成员




--tableName是可变的,所以我想用预处理sql语句来处理
set @tableName='';
select get_table_name(param1) into @tableName;
--我的问题就是下面 @outParam 怎么样才能在预处理sql语句中作为参数传出来
set @outParam=0;
set @strSql = concat('select c1 into @outParam from',@tableName);
prepare st from @strSql;
execute st;
deallocate prepare st;
set @outParam=0;
set @strSql = concat('select @outParam:=c1 from',@tableName);