未定义变量o

Question

我试图在MySQL中创建一个过程。这是正文：

BEGIN

DECLARE _date_delivered datetime;
DECLARE _date_last_comment datetime;
DECLARE _buyer_id int;
DECLARE _date_finish_line datetime;

   SELECT o.date_delivered INTO _date_delivered,o.buyer_id INTO _buyer_id, h.date INTO 
       _date_las_comment, DATE_ADD( h.date, INTERVAL _hours HOUR ) 
       INTO _date_finish_line 
   FROM wpk9_kk_order o 
   LEFT JOIN 
       wpk9_kk_order_history h ON 
       o.order_id = h.order_id WHERE o.order_id = _order_id AND h.user_id = o.buyer_id 
   ORDER BY h.date DESC;

   select _date_delivered,_buyer_id, _date_last_comment, _date_finish_line;
END

但是当我保存它时，我得到这个错误：

处理您的请求时发生了一个或多个错误：

以下查询失败：“创建定义器”=root@localhost过程getAutoFinishTimeRemaining（按_order_id INT，按_Hoursint）非确定性读取SQL数据SQL安全定义器开始声明_date_delivered datetime；声明_date_last_comment datetime；声明买方id int；声明_date_finish_line datetime；选择o.date_delivered to_date_delivered，o.buyer_id to_buyer_id，h.date to_date_las_comment，date_ADD（h.date，INTERVAL _hours)to_date_finish_line FROM wpk9_kk_order o LEFT加入wpk9_kk_order_order_历史记录h ON o.order_id=h.order_id=h.order_id，其中o.order_id=_order_id=_order_id=h和h.user_id=o.date DESC；选择“交货日期”、“买家id”、“日期”、“最后一次注释”、“日期”和“完成”行；结束“

MySQL说：#1327-未声明的变量：o

Answer 1

检查你的\u date\u last\u comment栏。在select语句中编写\u date\u last\u comment列时，您有一个输入错误。您已经编写了\u date\u las\u comment（错误消息中也可以清楚地看到）。

你的程序应该是：

BEGIN

DECLARE _date_delivered datetime;
DECLARE _date_last_comment datetime;
DECLARE _buyer_id int;
DECLARE _date_finish_line datetime;

   SELECT o.date_delivered INTO _date_delivered,o.buyer_id INTO _buyer_id, h.date INTO 
       _date_last_comment, DATE_ADD( h.date, INTERVAL _hours HOUR ) 
       INTO _date_finish_line 
   FROM wpk9_kk_order o 
   LEFT JOIN 
       wpk9_kk_order_history h ON 
       o.order_id = h.order_id WHERE o.order_id = _order_id AND h.user_id = o.buyer_id 
   ORDER BY h.date DESC;

   select _date_delivered,_buyer_id, _date_last_comment, _date_finish_line;
END