insert in between two rows
hey guys,
I have a have a huge database, and wanted to insert rows in between two rows.
sample table
+-------------+
| id | Name |
+-------------+
| 1 | Juan |
+-------------+
| 2 | Aaron |
+-------------+
what if i want to insert in between the rows 1 and 2 with using only single query. i'm talking about a huge database, like billions of rows. in addition `id` is auto_increment. Is this possible?
Subject
Written By
Posted
insert in between two rows
May 11, 2007 05:07AM
February 26, 2008 02:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.