Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [rage] how to delete links between id 2000 and id 3000

Jul 10, 2007, 2:36 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jul 10, 2007, 2:36 AM
Views: 4951
Shortcut
Quote Reply
Re: [rage] how to delete links between id 2000 and id 3000 In reply to
Hi,

First of all BACKUP VIUA MySQLMan! I won't be held responsible if this doesn't do what you want Tongue

Run (obviously replacing glinks_ with whatever you have):

DELETE FROM glinks_Links WHERE ID > 2000 AND ID < 3000

..and then:

DELETE FROM glinks_CatLinks WHERE LinkID > 2000 AND LinkID < 3000

...Then, you need to run Build > Repair Tables , to fix your category counts.

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread how to delete links between id 2000 and id 3000 rage 5103 Jul 9, 2007, 2:48 PM
Post Re: [rage] how to delete links between id 2000 and id 3000 		blacknight 4936 Jul 10, 2007, 2:25 AM
Thread Re: [rage] how to delete links between id 2000 and id 3000 		Andy 4951 Jul 10, 2007, 2:36 AM
Thread Re: [Andy] how to delete links between id 2000 and id 3000 		brewt 4955 Jul 10, 2007, 1:07 PM
Post Re: [brewt] how to delete links between id 2000 and id 3000 		Andy 4933 Jul 11, 2007, 2:47 AM
Thread Re: [brewt] how to delete links between id 2000 and id 3000 		rage 4901 Jul 13, 2007, 9:48 AM
Post Re: [rage] how to delete links between id 2000 and id 3000 		brewt 4933 Jul 13, 2007, 2:47 PM