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

Rearrange ID on database

Dec 31, 2002, 3:52 AM
reenee
User (411 posts)
Dec 31, 2002, 3:52 AM
Post #1 of 3
Views: 1459
Shortcut
Quote Reply
Rearrange ID on database
Hi All,

How can i reorder/rearrange all ID on my database by using SQL monitor ? This because some ID are skipping ..sometime it has been use and sometime is blank ..so i need rearrange base on total link on my database.

Please help

Last edited by:

reenee: Dec 31, 2002, 3:58 AM
Dec 31, 2002, 8:01 AM
webmaster33
Veteran (2312 posts)
Dec 31, 2002, 8:01 AM
Post #2 of 3
Views: 1408
Shortcut
Quote Reply
Re: [reenee] Rearrange ID on database In reply to
You'd better do an export then import back your table. Hopefully the problems will be gone.
Be sure to do full db backup before you do that.

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
Dec 31, 2002, 3:11 PM
Alex
Administrator (9387 posts)
Dec 31, 2002, 3:11 PM
Post #3 of 3
Views: 1388
Shortcut
Quote Reply
Re: [reenee] Rearrange ID on database In reply to
Hi,

It's perfectly ok for the ID's to have gaps in them. That should not cause any problems. Is there another reason you want to do this?

Cheers,

Alex
--
Gossamer Threads Inc.