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