Shulou(Shulou.com)06/01 Report--

Almost all stored procedures developed by MySQL require parameters. These parameters make stored procedures more flexible and useful. In MySQL, there are three modes for parameters: IN,OUT or INOUT.

1, single parameter in

DELIMITER $$

USE dc3688 $$

CREATE PROCEDURE GetOfficeByCountry (IN countryName VARCHAR)

BEGIN

SELECT *

FROM offices

WHERE country = countryName

END$$

DELIMITER

2, multiple parameters (in out)

DELIMITER $$

CREATE PROCEDURE CountOrderByStatus (

IN orderStatus VARCHAR (25)

OUT total INT)

BEGIN

SELECT count (orderNumber)

INTO total

FROM orders

WHERE status = orderStatus

END$$

DELIMITER

Call method

CALL CountOrderByStatus ('Shipped',@total)

SELECT @ total

3. Parameter inout

DELIMITER $$

CREATE PROCEDURE set_counter (INOUT count INT (4), IN inc INT (4))

BEGIN

SET count = count + inc

END$$

DELIMITER

Calling procedure

SET @ counter = 1

CALL set_counter (@ counter,1)

You can actually use different parameters.

The article is from www.dc3688.com.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.