Batch delete

If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics

Search

[Hottest Topics]

Hottest Topics [Members]

[Members]

Member Listing [FAQ]

[FAQ]

FAQ

[Register]

Register /

Batch delete

XML

Forum Index » Advanced Guestbook Forum

Author

Message

[Post New]

04/03/2007 12:14:27

Subject: Batch delete

Lisa_s
Newbie

Joined: 26/11/2005 17:05:10
Messages: 1
Offline

I would like to prune my guestbook so that all entries older than 3 months are automatically removed

Are all tables linked by a datetime stamp that a single SQL statement could do that?

Or is there another way?

Thnx
Lisa

[Post New]

04/03/2007 13:26:56

Subject:

Carbonize
Master

Joined: 12/06/2003 19:26:08
Messages: 4292
Location: Bristol, UK
Offline

All entries do contain a unix timestamp and so you could use aquery to delete any who's timestamp is over three months.

Carbonize
I am not the maker of the Advanced Guestbook

get Lazarus

[Email]

[WWW]

[Yahoo!]

[MSN]

[ICQ]

Forum Index » Advanced Guestbook Forum

Based on the open source JForum