Re: insert in between two rows

[anodynepres]

I'm not sure I understand why you would want to do this. If the ID column is using an auto_increment, that would suggest that this is a surrogate key which means it doesn't provide any additional information about the entity you're modeling.

If you were able to do this (and I don't think you are), that would mean updating over a billion records to insert one. I think you would be better served by letting your auto-increment run normally and add an appropriate index to allow you to retrieve your records more efficiently. No matter what you do, though, working with that much data is going to present challenges.