SQLite database
There is a
tableAID and name two columns
Specific data for the
ID name
1 6
2 2
3 3
4, 5
5 4
6 1

1. When the delete id for this row data after
Id 4 update for 3
Id 5 update for 4
Id 6 update for 5
So on

2. Click replace button automatically according to the Name sort
Update the ID at the same time, the specific data updated the following
ID name
1 1
2 2
3 3
4 4
5 5
6 6

The solution, for help,

CodePudding user response:

The growing popularity of this kind of design can put a little programming experience "death", this software will be jammed, throw away, you go back to measure the process feasibility in reality, the hypothesis has a record of 10000 vehicles with taxi, every day for a month, you delete a updates records of all the other, so the system many times slower?

CodePudding user response:

Look what I found, prehistoric questions about
https://bbs.csdn.net/topics/380099364