MYSQL存储过程传入传出

MYSQL储存过程传入传出

DELIMITER //

CREATE PROCEDURE cc(IN OrderID char,IN MysqlP_Price decimal,IN PayMode INT,OUT OrderStatus int)

BEGIN

UPDATE OrderList

SET OrderStatus=’3′,

ProPrice=MysqlP_Price

WHERE OrderID=OrderID and OrderStatus=’0′ AND PayMode=PayMode;

  SELECT OrderStatus into OrderStatus FROM OrderList WHERE OrderID=OrderID;

END//

call cc(‘20120507000953605783′,’99.00′,’3’,@OrderStatus);

结果

ERROR 1172(42000) result consisited of more than one row

请问一下

我需要先传值进去，再更新表，最后将订单的当前状态值（Orderstatus）返回出来,请问该如何来写

CREATE PROCEDURE cc(IN OrderID char,IN MysqlP_Price decimal,IN PayMode INT,OUT OrderStatus int)

参数名改下，不要跟表的字段名一样，再试下




SELECT OrderStatus into OrderStatus FROM OrderList WHERE OrderID=OrderID这个结果不唯一？

SELECT OrderStatus into OrderStatus FROM OrderList WHERE OrderID=OrderID limit 1;这样




desc OrderList

贴出来看一下表结构。