Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

How to delete unvalidate links all at once?

Dec 24, 2001, 1:47 PM
bearvv
New User (1 post)
Dec 24, 2001, 1:47 PM
Post #1 of 2
Views: 1335
Shortcut
Quote Reply
How to delete unvalidate links all at once?
Hi all,

Can any body tell me how can I delete all unvalidate links all at once at mysqlman or through commad line? Becasue I have around 60000 unvalidate links which are unless for me and I don't know how to delete them all at once. If I delete them one by one, it will sure takes a real long.

Thanks.

Bear
Dec 26, 2001, 4:28 PM
Nicky
User (199 posts)
Nicky's avatar
Dec 26, 2001, 4:28 PM
Post #2 of 2
Views: 1245
Shortcut
Quote Reply
Re: [bearvv] How to delete unvalidate links all at once? In reply to
hmmm...

Code:
DELETE FROM yourprefix_Links WHERE isValidated = 'No'

BUT

in this tables you must(should) delete the relations too
(but you should write your own script with "LEFT JOIN ON")
prefix_CatLinks
prefix_Users

and maybe here (if the links was validated!)
prefix_ClickTrack
prefix_Reviews
prefix_Verify
prefix_Changes


----
ciao
nicky

Last edited by:

Nicky: Dec 26, 2001, 4:29 PM