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

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 .

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

That looks like a field name - the table name is probably 'links' or something similar.

thank you! it worked