How to insert a row into a table between two existing rows in Sql

Question

I have a table with 9 records, but I want to insert a row between the 5th and 6th records.

Answer 1

if you insist on

UPDATE mytable SET id = id + 1 where id > 5 ORDER BY id ASC insert into mytable (id,..) values (6,...) 

Answer 2

In general, you do not insert a row at a specific place in the table.

If the line "order" is significant and has some special semantics, the data reflects this with the corresponding column in the table structure.

Then use SELECT ... ORDER BY ... to sort the rows.