Help
I have a auto increment id - int(10)
i have a table Id int(10)autoincrement, name varchar(20);
Suppose i have 10 records in table.
now i want to delete 4th and 5th record . and i am inserting 5 new record in table.
so now from 5 new records first two records shld be assigned to 4 and 5th record and rest 3 records are from 11,12,13.
Suppose
1 - A
2 - B
3 - C
4 - D
5 - E
6 - F
7 - G
8 - H
9 - I
10 - K
now i am deleting record 4 and 5 and inserting 5 new records so it shld be inserted like this
1 - A
2 - B
3 - C
4 - L
5 - M
6 - F
7 - G
8 - H
9 - I
10 - K
11 - N
12 - O
13 - P
I dont want to do update operation
Please guide.
Subject
Views
Written By
Posted
Help
2580
June 24, 2010 04:27AM
1441
June 26, 2010 02:15PM
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.