Delete Magento Order & Invoice

magento_delete_roders.sql

set @increment_id='300001114';
  select @order_id:=entity_id from sales_flat_order where increment_id=@increment_id;
  delete from sales_flat_order where entity_id=@order_id;
  delete from sales_flat_order_grid where increment_id=@increment_id;
   delete from sales_flat_order_payment where parent_id=@order_id;
   delete from sales_flat_order_status_history where parent_id=@order_id;
    select @tax_id:=tax_id from `sales_order_tax` where order_id=@order_id;

   delete from sales_order_tax_item where tax_id=@tax_id;
   
   select @invoice_id:=entity_id from sales_flat_invoice where order_id=@order_id;
   delete from sales_flat_invoice where order_id=@order_id;
   delete from `sales_flat_invoice_item` where parent_id = @invoice_id;
   delete from `sales_flat_invoice_grid` where `order_increment_id` = @increment_id;