Karl Martin Skoldebrand schrieb am 02.07.2019 um 13:20:
>>> Now I want to insert more countries, between France and Ireland.
>>
>> That is a wrong assumption - there is no "between" for rows in a
>> relational database.
>>
>
> Yes, I'm fairly aware of this. However the application the
> database table belongs to seems to rely on a specific order in the
> database. I.e. if I just add value to the table they end up, possibly
> due to how the application is coded in an undesireable spot on the
> web page. That is why I wanted them to be inserted with the previous
> records.
There is no "order of rows" in a relational database.
Even _if_ you squeeze the IDs of the new rows between existing ones,
you still have no guarantee whatsoever on the order of the rows
returned by a SELECT statement.
The only(!) way to get a guaranteed sort order is to use ORDER BY.
Thomas
