If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / Delete Old Order IDs 1 to 3369 Using SQL Query

Delete Old Order IDs 1 to 3369 Using SQL Query

Started by limelites on 12 Apr 2013, 10:47 AM · Views: 545

Results 1 to 2 of 2
12 Apr 2013, 10:47 AM
#1
limelites avatar

limelites

Totally Zenned

Join Date:
Jan 2009
Posts:
2,085
Plugin Contributions:
0

Delete Old Order IDs 1 to 3369 Using SQL Query

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.

12 Apr 2013, 1:29 PM
#2
limelites avatar

limelites

Totally Zenned

Join Date:
Jan 2009
Posts:
2,085
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!!