标题: MYSQL循环语句使用
简介: MYSQL循环语句跟SQLSERVER有区别:delimiter $$drop procedure if exists wk;create procedure wk()BEGINDECLARE i int;set i=62
时间:2018-03-30 10:18:25

MYSQL循环语句跟SQLSERVER有区别:

delimiter $$
drop procedure if exists wk;
create procedure wk()
BEGIN
DECLARE i int;
set i=620;
  while (i<748) DO
insert into operationlist values('',1,1,i,1,'2018-03-30 08:56:00','最长字符串',0,'','',1,'这里的不用改',1);
set i=i+1;
  end while;
END $$
 
delimiter ;
call wk();