What would the SQL syntax be to run a SQLQUERY that deletes all records pertaining to order number 1-3369
orders
orders_products
orders_products_attributes
orders_products_download
orders_status_history
orders_total
Just need to clear out some of the really old orders. If it's easier to do by a date range then that's an option too.
Results 1 to 2 of 2
-
12 Apr 2013, 11:47 AM #1
Totally Zenned
- Join Date
- Jan 2009
- Posts
- 2,123
- Plugin Contributions
- 0
Delete Old Order IDs 1 to 3369 Using SQL Query
-
12 Apr 2013, 02:29 PM #2
Totally Zenned
- Join Date
- Jan 2009
- Posts
- 2,123
- Plugin Contributions
- 0
Re: Delete Old Order IDs 1 to 3369 Using SQL Query
Hmmm, it's ok I've found a really good tool for this at apsona.com and it's free! Perfect!!
Reply With QuoteSimilar Threads
-
Bulk change to order status using SQL query for certain products?
By neo2810 in forum Managing Customers and OrdersReplies: 3Last Post: 24 Feb 2012, 08:34 PM -
SQL Query for extracting Order & Customer Details?
By Rony in forum Managing Customers and OrdersReplies: 7Last Post: 23 Sep 2010, 10:47 PM -
How do I change multiple product names all at once using an SQL Query?
By raguirre in forum General QuestionsReplies: 2Last Post: 8 Jan 2009, 01:00 PM -
SQL Query to Delete All Products Only
By toussi in forum General QuestionsReplies: 0Last Post: 26 Nov 2008, 06:57 PM -
How to delete old orders from order history?
By David Bo in forum Managing Customers and OrdersReplies: 3Last Post: 17 Jan 2008, 06:31 AM
