首页 > 其他 > 详细

sdasd

时间:2016-04-14 22:16:23      阅读:125      评论:0      收藏:0      [点我收藏+]
create PROCEDURE v4(in c_year int)
BEGIN
	declare num int(10) default 0;
	declare num1 int(10);
			select code into num from class where class=c_year order by code desc limit 1;
				
		IF exists(select * from class where class=c_year) THEN
							
				    insert into class(class,code)values(c_year,num+1);
		else 
				insert into class(class,code)values(c_year,1);	
	end if;			

end;

  

BEGIN
 DECLARE a_class VARCHAR (10);
 DECLARE a_code int (10);
 DECLARE a_int INT (10);
SELECT IFNULL(class, class) INTO a_class;
select SUBSTR(‘0000‘,4,4)+‘0‘ into a_code;
select a_int=a_code+1;
IF class = a_class THEN
  IF a_int<10  THEN
			insert into class(class,code)VALUES(a_class,CONCAT(a_class,‘000‘,a_int));
	elseIF a_int <100 THEN
			insert into class(class,code)VALUES(a_class,CONCAT(a_class,‘00‘,a_int));
	elseIF a_int <1000 THEN
			insert into class(class,code)VALUES(a_class,CONCAT(a_class,‘0‘,a_int));
	elseif a_int<10000 THEN
			insert into class(class,code)VALUE(a_class,concat(a_class,a_int));
end if;
end if;
set  a_int=a_code+1;
end

  

sdasd

原文:http://www.cnblogs.com/mengluo/p/5392866.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!