MySQL stored procedures

--create table

CREATE Table TestProcedure (

Testprocedureid Int (one) unsigned NOT NULL auto_increment,

procedurename varchar () 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 (), 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 stored procedures