怎样在mysql 存储过程的sql语句里插入变量?

2025-03-09 12:38:39
推荐回答(2个)
回答1:

mysql> create procedure pro10()
-> begin
declare @i int;
-> set @i=1;
-> while @i<5 begin
-> insert into t1(ff) values('第'+ @i +'条');
-> set @i=@i+1;
end
end

回答2:

declare @i int;
set @i=1;
while i<5
begin
insert into t1(ff) values("第"+ @i +"条");
set @i=@i+1;
end