I forget the actual table name now, but it is something like
USageOnlineHours or UsageData_OnlineHours. You would just need to delete
all data in that table ie.:

---
DELETE FROM UsageOnlineHours
---

You would need to check which table though.

---
You know when you've been online too long when...You say BRB because
you're going somewhere.


(--------------------------------)         {((((((
(     Suneel Jhangiani           )        /_  _  )
(    Technical Director          )       ( .  .   )
( Inter-Computer Technology Ltd. )        ( /   )
(----------------------------------oOOo------------oOOo----)
( 40 James Street                Tel: +44 (0) 20 7486 9601 ) 
( London W1U 1EU                 Fax: +44 (0) 7050 678 978 )
( United Kingdom               Email: [EMAIL PROTECTED]     )
(             Website: http://www.inctech.com              ) 
(----------------------------------------------------------)




-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Gary Carr
Sent: 01 July 2004 18:25
To: [EMAIL PROTECTED]
Subject: [Rodopi] script to delete all online usage

Anyone have a sql script to remove all online usage from the rodopi
database?



Thanks,



Gary





---------------------
To Leave the Rodopi mail list send a message to
[EMAIL PROTECTED] 
with the word LEAVE as the message body.

Please also visit the Rodopi FAQ at http://www.rodopi-faq.com
---------------------





---------------------
To Leave the Rodopi mail list send a message to [EMAIL PROTECTED]
with the word LEAVE as the message body.

Please also visit the Rodopi FAQ at http://www.rodopi-faq.com
---------------------

Reply via email to