Insert value in Auto_Increment field?

[4rxsid]

Hi all,

I have an Auto_Increment field with, for example, 100 entries that are based on dated information.

I need to be able to go back and insert additional rows in between what is currently stored. For example, I would like to be able to insert another record at entry #51 and push all the auto_incremented numbers after that, up by one.

Is something like this possible?

Thanks.

[barand]

You could extract the data into a similar table without the auto_increment field, add your records, sort into date sequence then drop your original table, re-create it and then load the data back into it.

Alternatively you could just add the new records at the end, index the table on the date field and query the table with an "ORDER BY datefield".

The auto_inc field just ensures every record has a unique id. You don't always have to extract them in that sequence.

[4rxsid]

barand...thanks for the advice!

sometimes it seems the "simple" and practicle solutions are overlooked. i was trying to look for a programatic solution.

i went with indexing the date field.

[barand]

I thought you would 🙂