mysqlif⽤法多个条件判断、字符串⽐较use industry_finance;
DELIMITER //
drop procedure if exists  updateCursor //
CREATE PROCEDURE updateCursor()
BEGIN
declare id varchar(20);
declare month varchar(20);
declare season varchar(20);
declare cur1 CURSOR FOR SELECT ID_,month_ FROM t_industry_finance_instance;
OPEN cur1;
FETCH cur1 INTO id,month;
WHILE (id is not null ) DO
if(month='01'||month='02'||month='03') THEN  set season='1';
end if;
if(month='04'||month='05'||month='06') THEN  set season='2';
exists的用法end if;
if(month='07'||month='08'||month='09') THEN  set season='3';
end if;
if(month='10'||month='11'||month='12') THEN  set season='4';
end if;
update t_industry_finance_instance  set  season_=season  where ID_=id;
FETCH cur1 INTO id,month;
END WHILE;
CLOSE cur1;
END;//
DELIMITER ;
call updateCursor();

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。