delimiter $$
create procedure add_student_info(
in p_userName varchar(20),
in p_phone varchar(20),
in p_sex char(2),
in p_introduce varchar(200)
)
begin
insert into student (userName,ohone,sex,introduce) values
(p_userName,p_phone,p_sex,p_introduce);
end $$
delimiter ;
call add_student_info('小小怪','12343234321','男','大大怪');
select * from student where introduce like '哈哈哈';
mysql查询
最新推荐文章于 2024-08-06 15:20:26 发布