Welcome, Guest ( Customer Panel | Login )




 All Forums
 VPCart Forum
 General help me questions
 Bulk Tracking Deletion
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Mark Priest
VP-CART Expert

United Kingdom
580 Posts

Posted - September 07 2006 :  19:36:18  Show Profile  Reply with Quote
Hi All

Can anyone help me with the MySQL command to delete all the tracking messages before a certain date?

Regards,

Mark

dafragan
Starting Member

45 Posts

Posted - September 07 2006 :  19:41:14  Show Profile  Reply with Quote
Hi Mark!

Try this query -

DELETE FROM ordertracking WHERE trackdate <= '2006-08-01'

You can change the date as you need to.

Seb
Go to Top of Page

Mark Priest
VP-CART Expert

United Kingdom
580 Posts

Posted - September 08 2006 :  03:40:12  Show Profile  Reply with Quote
Cheers Sebastian,

Will try that.

Regards,

Mark
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00