Mysql persistense, reset and rename items

Hello,

I have two questions. Is there a way to set the new Item# number. Reason I ask is that due to an access problem my current new Item# has jumped far off my existing numbers.

Secondly, can I re-number items by altering the Items table with a new Item# table name id?

Kind regards,
Bastiaan van Haastrecht

Anyone?