存储过程和函数

# MySQL创建存储过程函数
# 存储过程使用大纲
delimiter $$
# 声明一个名称为get_student_introduce
create procedure get_student_introduce()
# 开始操作
begin
# 撰写真正在操作DML+DQL都行
set @userName='龙姑娘';
select introduce '简介'from student where userName=@userName;
end $$
delimiter ;

delimiter $$
create procedure get_student_introduce1(in p_name varchar(20))
begin

select introduce '简介'from student where userName=p_name;
end $$
delimiter ;

delimiter $$
create procedure add_student_infor(
in p_userName varchar(20),in p_phone varchar(11),in p_sex char(2),in p_introduce varchar(255))
begin
insert into student(userName,phone,sex,introduce) values ( p_userName,p_phone,p_sex, p_introduce);
end $$
delimiter ;
call add_student_infor('李弘扬','13812345678','男','承德市最有深情的男人。');

select * from student where userName='李弘扬';