MySQL stored procedures

1. Simple Stored Procedure creation

Drop procedure if exists  //  CREATE definer=PROCEDURE  ' Selectorder ' ()  BEGIN    Select* from order_h; END // Call Selectorder ();

2. Stored procedure creation with parameters

Drop procedure if existsSelectorder;delimiter//  CREATE PROCEDURE' Selectorder ' (inchCustomervarchar( +))BEGIN    Select *  fromOrder_hwhereCustomerID=customer;END//Call Selectorder ('Ct9');

3. Create a stored procedure with a parameter

Drop procedure if existsSelectorder;delimiter//  CREATE PROCEDURE' Selectorder ' (out Money int)BEGIN    Select sum(Summoney) into  Money  fromOrder_hwhereCustomerID='Ct9';END//Call Selectorder (@money);SELECT @money  fromDUAL;

4. Create a stored procedure with a parameter entry

Drop procedure if existsSelectorder;delimiter//  CREATE PROCEDURE' Selectorder ' (inchCustomervarchar( +), out Money int)BEGIN    Select sum(Summoney) into  Money  fromOrder_hwhereCustomerID=customer;END//Call Selectorder ('Ct1',@money);SELECT @money  fromDUAL;

5. Stored Procedure Control statements

Drop procedure if existsSelectorder;delimiter//  CREATE PROCEDURE' Selectorder ' (inchCustomervarchar( +),inchIsmax Boolean, out Money int)BEGIN    ifIsmax Then        Select Max(Summoney) into  Money  fromOrder_hwhereCustomerID=customer; Else        Select min(Summoney) into  Money  fromOrder_hwhereCustomerID=customer; End if; /** Other syntax declaration variables DECLARE s int;        While loop while I <= n does set S = s + i;                END while;        Case if case type is 0 Then set c = ' false ';        When 1 then Set c = ' true ';        else Set c = ' Else ';    END case; */END//Call Selectorder ('Ct1', False,@money);SELECT @money  fromDUAL;

MySQL stored procedures