Only add data, such as a data update, the provincial government front machine will have two data, is to insert a day, a day is the update, the beginning of data in a central one insert, later to become the update, so how to extract data?

CodePudding user response:

Add a insert a timestamp and update timestamp

CodePudding user response:

Why are there 2 data?

After the update, is only 1 the latest data, according to this demand of you, does that mean if the data update it again, is the article 3?

CodePudding user response:

Demand is not clear, frontend and consolidated storage, that is the source of data for you to take? What kind of data you want to take?

CodePudding user response:

Junction post rate: 0%

reference

after your questions answered please post.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html

8, how to give points and knot stick?
http://bbs.csdn.net/help#post_dispose

CodePudding user response:

Suggest you list your table structure, and provide the test data, and based on these test data that corresponds to the correct result,
Refer to the way the post questions http://bbs.csdn.net/topics/320211382

1. You create table XXX.. Statement
2. You insert into XXX... Statement
3. The result is what kind, and give a simple algorithm description)
4. Do you use the database name and version of (often asked in MS SQL server edition MySQL)

So people who want to help you to build the same environment with you directly, and in providing the test before, avoid the error in the text understanding,