mysql循环存储过程_MySQL

bitsCN.com

mysql循环存储过程

 

利用存储过程执行一批语句

DELIMITER $$

 

DROP PROCEDURE IF EXISTS `proc1`$$

 

CREATE  PROCEDURE `proc1`()

BEGIN

declare i integer;

set i=0;

while i

begin

set @TABLENAME=CONCAT('update  ','sns_userinfo_ext_',i,' set mobile_flag=1,mail_flag=1;');

PREPARE STMT FROM @TABLENAME;   

EXECUTE STMT;   

SET i=i+1;

end;

end while;

END$$

 

call ff()

 

bitsCN.com