Gossamer Forum: Products: Gossamer Links: Discussions: Re: [bearvv] How to delete unvalidate links all at once?: Edit Log

Gossamer Threads

Home : Products : Gossamer Links : Discussions :

Products: Gossamer Links: Discussions: Re: [bearvv] How to delete unvalidate links all at once?: Edit Log

Here is the list of edits for this post

Dec 26, 2001, 4:28 PM

Nicky

User (199 posts)

Dec 26, 2001, 4:28 PM

Re: [bearvv] How to delete unvalidate links all at once?

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

Edit Log:

Post edited by Nicky Post edited by Nicky (User) on Dec 26, 2001, 4:29 PM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676