定义过程示例。e.g.:如前所述,先把默认结束符换掉,执行delimiter //,然后执行CREATE PROCEDURE simpleporc (OUT param1 INT) BEGIN SELECT COUNT(*) INTO param1 FROM t END //调用:CALL simpleproc(@a);
定义函数示例。e.g.:CREATE FUNCTION hello(s CHAR(20)) RETURNS CHAR(50) RETURN CONCAT('Hello,',s,'!');//(当然,也要把结束符先换掉)