VP-ASP :: Shopping Cart Software

Shopping Cart Software Solutions for anywhere in the World

US/Canada(Toll Free): +1 888 587 2278
Europe/UK: +44 (020) 7193 9408
Australia/New Zealand: +61 3 9016 4497

VP-ASP Shopping Cart Customer Forum

Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 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-ASP Expert

United Kingdom
570 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-ASP Expert

United Kingdom
570 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