mysql修改库删除表点菜软件退菜明细修改
发布时间：2026/10/20 17:07:42 作者：Admin 阅读：8
广告：
# The MySQL server
[mysqld]
skip-grant-tables
原始存储过程：
BEGIN
select rvc_center_id as rvc_id,
rvc_center_name as rvc_name,table_id as table_id,
table_name as table_name,
history_order_detail.order_head_id as order_head_id,
history_order_detail.check_id as check_id,
history_order_head.check_number as chk_num,
order_employee_id,order_employee_name,menu_item_id,menu_item_name,
return_time,abs(actual_price) as actual_price,abs(quantity) as quty,
return_reason,auth_id,auth_name from history_order_detail,history_order_head
where history_order_detail.order_head_id=history_order_head.order_head_id AND history_order_detail.check_id=history_order_head.check_id
and (is_return_item=1 OR quantity<0) and menu_item_id>0
and history_order_detail.return_time >=s_time
and history_order_detail.return_time <=e_time
and history_order_head.rvc_center_id>=1 and history_order_head.rvc_center_id<=3
and history_order_detail.order_employee_id>=0
and history_order_detail.order_employee_id<=99999
order by history_order_detail.order_employee_id;
END
这是一篇受密码保护的文章，请输入密码进行访问：
广告：
相关文章
