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

/*修改订单时间*/
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";  */