mysql in存储_MySQL存储过程带in和out参数

MySQL存储过程带in和out参数

最简单的例子:

[html]

mysql> DELIMITER $$

mysql> USE test $$

Database changed

mysql> DROP PROCEDURE IF EXISTS `sp_add`$$

Query OK, 0 rows affected (0.00 sec)

mysql> CREATE PROCEDURE sp_add(a INT, b INT,OUT c INT)

-> BEGIN

-> SET c=a+ b;

-> END$$

Query OK, 0 rows affected (0.00 sec)

mysql> DELIMITER ;

[html]

mysql> CALL sp_add (1,2,@c);

Query OK, 0 rows affected (0.00 sec)

mysql> SELECT @c;

+------+

| @c |

+------+

| 3 |

+------+

1 row in set (0.00 sec)

一个稍微复杂的例子:

[html]

mysql> show create table t_BillNo;

+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| Table | Create Table |

+----------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| t_BillNo | CREATE TABLE `t_billno` (

`SaleNo` bigint(20) DEFAULT NULL,

`bmh` varchar(20) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC |