MySQL stored procedures

Name	Age	Phone
Chen	25	134xxxx
Zhang	30	158xxxxx

Grammar:

 create  procedure  Procedure name ([ [in| Out| INOUT   parameter name data type [ ,[in| Out| INOUT   parameter name data type ...]) [  properties ...  ]  procedure Body 

int)    BEGIN      COUNT (fromEND    

Example with in Parameter

DROP PROCEDURE IF EXISTSIn_param; DELIMITER //CREATE PROCEDUREIn_param (inchPara_inINT)BEGINSELECT *  fromTable1WHEREAge=para_in;END ;
DELIMITER#调用SET @para_in =  -; Call In_param (@para_in);

MySQL stored procedures