存储过程的问题

[dinghao517]

我想存储过程中取出一个表的某行中的某个数据，然后打印
drop procedure if exists random;
create procedure random(in num int)
begin
declare nname char(20);
SET @sql = CONCAT('select course.name into nname from course
where course.term = "第三年第二学期"
limit ',ceil (num+1),',1;');
PREPARE stmt FROM @sql;
EXECUTE stmt;
select nname;

end
现在的问题在于，我无法给nname赋值。。。。

[rucypli]

不用动态

drop procedure if exists random;
create procedure random(in num int)
begin
declare nname char(20);

select course.name into nname from course
where course.term = "第三年第二学期"
limit ceil(num+1),1;

select nname;

end

[ACMAIN_CHM]

create procedure random(in num int)
begin
declare nname char(20);
SET @sql = CONCAT('select course.name into @nname from course
where course.term = "第三年第二学期"
limit ',ceil (num+1),',1;');
PREPARE stmt FROM @sql;
EXECUTE stmt;
select @nname;

end

[Rotel-刘志东]

create procedure random(in num int)
begin
    declare @nname char(20)
set @sql=concat('select course.name into @name from course
where course.term="第三年第二学期“
limit',ceil(num+1),',1;');
prepare stmt from @sql
execute stmt;
end