1、where循环
create procedure p_addnum()
begin
declare i int default 1;
declare addresult int default 0;
while i <= 100 do
set addresult = addresult + i;
set i = i + 1;
end while;
select addresult;
en
--声明变量；
DECLARE @i int
DECLARE @username varchar(30)
DECLARE @password varchar(30)
Set @i = 1000
--开始 循环 插入数据；
WHILE @i
BEGIN
Set @i =@i +1
SET @username = RIGHT('00000' + CAST(@i AS
示例数据库为postgre:# 1. insert ：create or replace function aa1() returns void AS $$ declare num integer; declare sname char; begin num := 0; while num &lt;=44 loop insert into system values...
本版专家分：10结帖率 100%
