源代码:
<!-- lang: sql -->
CREATE PROCEDURE AvgFruitPrice4()
BEGIN
SELECT AVG(f_price) AS avgprice
FROM fruits;
END;
解决方法1:
<!-- lang: sql -->
delimiter $$
CREATE PROCEDURE AvgFruitPrice4()
BEGIN
SELECT AVG(f_price) AS avgprice
FROM fruits;
END $$
解决方法2:
<!-- lang: sql -->
CREATE PROCEDURE AvgFruitPrice4()
SELECT AVG(f_price) AS avgprice
FROM fruits;