delimiter $$
DROP PROCEDURE IF EXISTS update_user_account_method;
CREATE PROCEDURE update_user_account_method()
BEGIN
create temporary table if not exists tmp(id bigint(20) primary key,ac varchar(20) not null) ;
truncate table tmp;
SET @num=(SELECT COUNT(1) FROM t_hospital);
WHILE @num>0 DO
select @num;
-- 变量
select @code:=code from t_hospital LIMIT 1;
select @code;
SET @num=@num-1;
END WHILE;
drop table tmp;
END $$
-- CALL update_user_account_method;
-- DROP PROCEDURE update_user_account_method;
MySQL批处理存储过程
最新推荐文章于 2022-07-03 09:12:23 发布