0318-sql脚本

DELIMITER $ //定义结束符 是注释
drop procedure  if exists P1;  //删除原有的重名procedure
create procedure P1()   //定义procedure
BEGIN  //开始结束
DECLARE x int;  //声明变量
SET x = 1;  //赋值
WHILE x <= 10 DO  //循环
INSERT INTO `students` ( `Name`, `qq`, `Worktype`, `TimeOfEnrollment`, `SchoolTag`, `StuNum`, `LinkofJournal`, `Wish`, `AdvisorSenior`, `KnewFromWhere`)VALUES ( '金石开', '1050376715', '产品经理', '2018-07-10', '北京师范大学', 1, '[http://www.jnshu.com/school/28015/daily](http://www.jnshu.com/school/28015/daily)', '如果我不能在IT特训营拼尽全力，为自己以后的 修行路上打好基础，就让我变胖2斤！', '李天宇', '朋友推荐');
update students set StuNum=x+3 where id=x+10;  //sql块
SET  x = x + 1;
end while; //循环结束
end $  //procedure结束
call P1()$  //调用procedure
DELIMITER ; //换回结束符

另外两种循环见下：
https://blog.csdn.net/aihali/article/details/46622349