Have certain data in the database, we remember as A, B, now I have A certain data data overlapping with A, B
I want to insert B database now, but want to take A - (A studying B) state of the data set 0, all data to B
State 1, what method is more efficient?

CodePudding user response:

B insert another table first, and then inserted the b a, a total of data conflict is inserted into the primary key
Inserted after all not the a b data in a state of 0, in 1 b data in a state

CodePudding user response:

https://www.cnblogs.com/shiwaitaoyuan/p/6483239.html

Can consider to merge with the merge

But attention should be paid to merge table use must be MyISAM engine