mysql 存储过程，使用sqlyog

无参数的：

DELIMITER $$

USE ets $$
DROP PROCEDURE IF EXISTS any_tj$$
CREATE PROCEDURE any_tj()
BEGIN
SELECT GROUP_CONCAT(FAYDM) FROM `ets_anyywb` GROUP BY ANYDM;
END$$

DELIMITER;

有参数的：

DELIMITER $$

USE ets $$
DROP PROCEDURE IF EXISTS any_tj$$
CREATE PROCEDURE any_tj(anydm VARCHAR(20))
BEGIN
SELECT GROUP_CONCAT(FAYDM) FROM `ets_anyywb` GROUP BY ANYDM HAVING ANYDM=anydm;
END$$

DELIMITER;

有入参和出参的：

DELIMITER $$
USE ets $$
DROP PROCEDURE IF EXISTS anj_tj $$
CREATE PROCEDURE anj_tj(
    IN anh VARCHAR(50),
    OUT anydm VARCHAR(20))
BEGIN
SELECT ANYDM FROM `ets_anjywxxb` WHERE ANH=anh;
SELECT @anydm;
END$$
DELIMITER;