mysql - 在 MySQL 中，如何创建一个带多个参数的存储过程？

Question

函数示例:调用 getThings(amount, place, limit, marginError)

概要:CALL getThings(4, PA, 3, 1.2);

目标示例:

CREATE PROCEDURE getThings(IN amount X, place VARCHAR(30), lim INT, marginError double)
SELECT place, limit, amount
FROM AREA, PRODUCT
WHERE AREA.place=PRODUCT.place
AND PRODUCT.AREA=place
ORDER BY ABS(AMOUNT-marginError)
LIMIT lim;
END

期望的目标是从存储过程(使用 MySQL)中检索最接近的 3 个产品，但我在尝试创建该过程时不断遇到语法错误。

Answer 1

因为您没有发布确切的错误/消息，

EDIT: I assume you are missing the IN/OUT for the 2.and 3. parameter. - Not true, see comments.

例如

DELIMITER$$
CREATE PROCEDURE getThings(IN amount X, IN place VARCHAR(30), IN lim INT)
   SELECT place, `limit`, amount
   FROM AREA, PRODUCT
   WHERE AREA.place=PRODUCT.place
   AND PRODUCT.AREA=place
   ORDER BY ABS(AMOUNT-5)
   LIMIT lim;
END$$
DELIMITER;