– 定义过程
delimiter $
create procedure dbs()
begin
show databases;
end $
delimiter ;
– 调用过程
call dbs;
– 删除过程
drop procedure dbs;
– 查看数据库中的过程
SELECT SPECIFIC_NAME
FROM INFORMATION_SCHEMA
.ROUTINES
WHERE ROUTINE_SCHEMA
= ‘emp’ AND ROUTINE_TYPE = ‘PROCEDURE’;
– 定义删除的存储过程 in out inout
delimiter $
create procedure p_del(in d1 int)
begin
delete from guestbook where id=d1;
end $
delimiter ;
call p_del(1);
– 定义插入的存储过程
delimiter $
create procedure p_add(d1 char(36),n1 varchar(36),m1 varchar(255))
begin
insert guestbook set id=d1,name=n1,msg=m1;
end $
delimiter ;
call p_add(‘1’,‘小明’,‘你好’);
– 带返回的存储过程
delimiter $
create procedure p_count(out n int)
begin
select count(*) into n from guestbook;
end $
delimiter ;
call p_count(@i);
select @i;
set @a=100;
select @a;
select @n:=55;
select @n;
if then
else
end if;
if(){
}else{
}