MySQL 存储过程示例

两种方法获取返回值

用select

DROP PROCEDURE IF EXISTS `getTableById`;

CREATE DEFINER = `root`@`localhost` PROCEDURE `getTableById`(IN `id` int)
BEGIN
SELECT * from nodelist t where t.id = id;

END;

用out模式或者inout模式

DROP PROCEDURE IF EXISTS `getInOutId`;

CREATE DEFINER = `root`@`localhost` PROCEDURE `getInOutId`(INOUT `id` int)
BEGIN
END;