Gossamer Forum
Quote Reply
ID count
someone submitted a 1000 junk links which i deleted all but when a new link is submitted it gets an ID=8001 how can i change the ID count back to 7001
Quote Reply
Re: [theguy] ID count In reply to
There is no real reason to do this - the ID number is used for tracking records internally and is mostly 'invisible' to the user.

If you really want to change it, you run the following MySQL query:

ALTER TABLE tablename AUTO_INCREMENT=x

where x is the number you want to start numbering new records from. Personally I wouldn't worry about it - we get ID numbers for free anyway Wink.
Quote Reply
Re: [aus_dave] ID count In reply to
this give s me an error:
ALTER TABLE links.ID AUTO_INCREMENT=7001

Error: Query Error: Failed to execute query: 'ALTER TABLE links.ID AUTO_INCREMENT=7001 ' Reason: Table 'links.ID' doesn't exist

Last edited by:

theguy: Jul 3, 2006, 2:47 AM
Quote Reply
Re: [theguy] ID count In reply to
That looks like a field name - the table name is probably 'links' or something similar.
Quote Reply
Re: [aus_dave] ID count In reply to
thank you! it worked