mysql循环存储过程_MySQL
程序员文章站
2022-04-22 11:49:14
...
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