use wechat;
drop procedure if exists insert_fun;
delimiter //
create procedure insert_fun(in nam VARCHAR(45),in psw VARCHAR(45),in s VARCHAR(45),in e VARCHAR(45),in bm int,in byy VARCHAR(45))
begin
insert into user(Name,Password,Sex,Email,birth_month,birth_year) values(nam,psw,s,e,bm,byy);
select * from user;
end //
delimiter ;
call insert_fun("ssdddd","xxx","male","asas","7","8");
存储过程mysql
最新推荐文章于 2024-07-24 13:13:54 发布