存储过程 3 的 mySql 错误 1064

Question

求助!!....下面有什么问题？？对于箭头指示的行，我收到 SQL 语法错误编号 1064。

CREATE PROCEDURE SP_IsProductInBasket (
  IN customerId INT(11),
  IN productId TINYTEXT
)
BEGIN
  SELECT
    products_id
  FROM customers_basket
  WHERE customers_id = customerId
    AND products_id = productId;    <------ error here????!!!
END

我已经验证了选择作为一个独立的工作正常

Answer 1

尝试更改分隔符，

DELIMITER $$
CREATE PROCEDURE SP_IsProductInBasket 
(
  IN customerId INT(11),
  IN productId TINYTEXT
)
BEGIN
  SELECT   products_id
  FROM     customers_basket
  WHERE    customers_id = customerId AND 
           products_id = productId;   
END $$
DELIMITER ;