Hello,

Quick question with auto_increment though.

I have added several records and deleted several records, but the ID automatically created starts at '54' for example - not '1'. How can I force it to start at '1', then the next record '2'?

Thanks

Chris

This should work:

ALTER TABLE `whatever` AUTO_INCREMENT=1

This will do the same, but delete all the data as well:

TRUNCATE TABLE `whatever`

Rufo

Ya that should solve your problem