Magento通过订单id修改订单创建时间的sql

本文详细介绍了如何使用SQL更新特定订单的时间戳,包括多个表的更新操作。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

/*修改订单时间*/
update sales_flat_order  set created_at="2015-04-12 06:13:47" where increment_id="100000689";
update sales_flat_order_grid  set created_at="2015-04-12 06:13:47" where increment_id="100000689";

update sales_flat_order_item as t1 
left join sales_flat_order as t2 on t2.entity_id=t1.order_id  
set t1.created_at="2015-04-12 06:13:47" where t2.increment_id="100000689";

update sales_flat_order_status_history as t1
left join sales_flat_order as t2 on t2.entity_id=t1.parent_id  
set t1.created_at="2015-04-12 06:13:47" where t2.increment_id="100000689" and t1.status="pending_payment";






/* 下面的表不要了*/
/* 
update sales_flat_quote as t1 
left join sales_flat_order as t2 on t1.reserved_order_id=t2.increment_id 
set t1.created_at="2015-03-24 06:53:20" where t2.increment_id="100000378";

update sales_flat_quote_address as t1 
left join sales_flat_quote as t2 on t1.quote_id=t2.entity_id
left join sales_flat_order as t3 on t2.reserved_order_id=t3.increment_id  
set t1.created_at="2015-03-24 06:53:20" where t3.increment_id="100000378";

update sales_flat_quote_item as t1 
left join sales_flat_quote as t2 on t1.quote_id=t2.entity_id
left join sales_flat_order as t3 on t2.reserved_order_id=t3.increment_id  
set t1.created_at="2015-03-24 06:53:20" where t3.increment_id="100000378";

update sales_flat_quote_payment as t1 
left join sales_flat_quote as t2 on t1.quote_id=t2.entity_id
left join sales_flat_order as t3 on t2.reserved_order_id=t3.increment_id  
set t1.created_at="2015-03-24 06:53:20" where t3.increment_id="100000378";


update sales_flat_quote_shipping_rate as t1 
left join sales_flat_quote_address as t2 on t1.address_id=t2.address_id
left join sales_flat_quote as t3 on t2.quote_id=t3.entity_id  
left join sales_flat_order as t4 on t3.reserved_order_id=t4.increment_id  
set t1.created_at="2015-03-24 06:53:20" where t4.increment_id="100000378";  */ 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值