MySQL Forums
Forum List  »  Optimizer & Parser

Help
Posted by: Ami Panchal
Date: June 24, 2010 04:27AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Help
2580
June 24, 2010 04:27AM


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.