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

ID count in deleting links

Mar 24, 2001, 10:17 AM
ridesworld
User (320 posts)
ridesworld's avatar
Mar 24, 2001, 10:17 AM
Post #1 of 4
Views: 1621
Shortcut
Quote Reply
ID count in deleting links
hello
I have some strange things with the link ID
when I add my first link it gets normally ID 1
when I delete this link, it works fine.
when I add my first link again it gets normally ID 2

How is this possible???
I repair the tables, and rebuild search.


Mar 24, 2001, 10:27 AM
Paul
Veteran (19537 posts)
Mar 24, 2001, 10:27 AM
Post #2 of 4
Views: 1582
Shortcut
Quote Reply
Re: ID count in deleting links In reply to
When you delete a link I don't think it deletes one from the LinkID total, it just stays as it is and so when you add the next URL it will go to two instead of from one to zero to one again.

I think anyway - I have a feeling I may not have got that right.

Paul Wilson.
http://www.wiredon.net/gt/
http://www.perlmad.com/
Mar 24, 2001, 4:20 PM
Stealth
Veteran (17240 posts)
Stealth's avatar
Mar 24, 2001, 4:20 PM
Post #3 of 4
Views: 1580
Shortcut
Quote Reply
Re: ID count in deleting links In reply to
That is how AUTO-INCREMENT field works in MySQLMan...When you set the primary key to AUTO-INCREMENT, it will assign the next available ID number...so, what you have explained is what should happen....

Read up on http://www.mysql.com and basic database field type definitions...

Regards,

Eliot Lee
Mar 25, 2001, 5:17 AM
ridesworld
User (320 posts)
ridesworld's avatar
Mar 25, 2001, 5:17 AM
Post #4 of 4
Views: 1566
Shortcut
Quote Reply
Re: ID count in deleting links In reply to
Oh thanks, I did not realise this, but the most important thing is, that this is not a bug in Links-SQL