mysql 預存程序

標籤：style   http   ar   os   sp   on   2014   ad   ef   

--create table

create table TestProcedure (

TestProcedureID int(11) unsigned not null auto_increment,

ProcedureName varchar(50) not null,

AddTime datetime not null,

primary key(TestProcedureID)

) engine=InnoDB default charset=utf8;

--insert data

insert into TestProcedure values(null, ‘steven‘, ‘2014-11-28 09:16:17‘);

--view data

select * from TestProcedure;

--set delimiter //

delimiter //

--create procedure

create procedure steven(IN IN_TestProcedureID int , OUT OUT_ProcedureName varchar(50), INOUT INOUT_Result varchar(255))

begin

select IN_TestProcedureID;

select OUT_ProcedureName;

select INOUT_Result;

select ProcedureName into OUT_ProcedureName from TestProcedure where TestProcedureID = IN_TestProcedureID;

set IN_TestProcedureID = IN_TestProcedureID + 1;

set INOUT_Result = concat(INOUT_Result, OUT_ProcedureName);

end

//

--set data

set @testProcedureID = 1//

set @procedureName = ‘heno‘//

set @result = ‘ready‘//

--call procedure

call steven(@testProcedureID, @procedureName, @result)//

--view data

select @testProcedureID//

select @procedureName//

select @result//

--set delimiter ;

delimiter ;

--show procedure detail

show create procedure steven;

--delete procedure

drop procedure steven;

mysql 預存程序