Question

MySQL创建存储过程错误

CREATE PROCEDURE 'Show_Product'(IN parameter INT)
BEGIN
SELECT p.productID,productName,SUM(SellCount) as TotalSell,Sum(StoredCount) as TotalStored
FROM product p,product_divide pd
WHERE p.productID=pd.productid AND warehouseID=parameter
GROUP BY p.productid,productName;
END;
请问哪里不对？
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Show_Product'(IN parameter INT) BEGIN SELECT p.productID,productName,SUM' at line 1

Answer 1

SELECT p.productID,productName,SUM(SellCount) as TotalSell,Sum(StoredCount) as TotalStored --上面都应该指定是那张表的数据
FROM product p,product_divide pd
WHERE p.productID=pd.productid AND warehouseID=parameter--指定是那张表
GROUP BY p.productid,productName;--这个也要指定
END;

Answer 2

他应该是提示变量名、列名不对吧