Insert into specific row in android sqlite database

Question

I'm looking for a way to insert a new entry into a specific row in an sqlite database in android. The basic idea is that the database stores entries like this:

id   day        time
1   Monday     09:00
2   Monday     11:00
3   Tuesday    10:00

the ID column is auto incremented. The idea is that if you wanted to insert a new entry of "Monday 10:00" it should be inserted into the database at id 2, and the other entries would update accordingly i.e. the entry "Monday 11:00" would become id 3 etc.

In short, is there any way to insert data into a specific row? If there is, will it automatically change the other entries?

Thanks

Answer 1

Short answer, no. Auto increment means you don't control the field.