I have a db that has blogs, the oldest is ID 1 and then every blog since has incremented, there are aprox 600 entries. Now I have received 4 blogs which were found and are dated before the existing oldest (row ID 1). I’m supposed to insert those into the db before row ID 1 so the historical order is maintained.
I thought maybe exporting and using Excel to renumber the existing rows, but when I try exporting as sql or csv the column that contains the row number also contains a parenthesis (in the csv, and even more extra data in the sql).
How can I insert 4 new rows before row ID 1?