MySQL - Auto Increment after delete
I have a MySQL table with a primary key field that has AUTO_INCREMENT on.
After reading other posts on here I've noticed people with the same problem and with varied answers. Some recommend not using this feature, others state it can't be 'fixed'.

I have:

*course table - with 2 fields - courseID, courseName*

Example:
Number of records in the table: 18<br>
If I delete records 16, 17 and 18 - I would expect the next record entered to have the courseID of 16, however it will be 19 because the last entered courseID was 18.

My SQL knowledge isn't amazing but is there anyway to refresh or update this count with a query (or a setting in the phpmyadmin interface)?

This table will relate to others in a database.

Any help is appreciated...
MySQL - Auto Increment after delete
===

I have a MySQL table with a primary key field that has AUTO_INCREMENT on.
After reading other posts on here I've noticed people with the same problem and with varied answers. Some recommend not using this feature, others state it can't be 'fixed'.

I have:

*course table - with 2 fields - courseID, courseName*

Example:
Number of records in the table: 18<br>
If I delete records 16, 17 and 18 - I would expect the next record entered to have the courseID of 16, however it will be 19 because the last entered courseID was 18.

My SQL knowledge isn't amazing but is there anyway to refresh or update this count with a query (or a setting in the phpmyadmin interface)?

This table will relate to others in a database.

Any help is appreciated...