It turned out that one and that base was refined in two cars. Both have duplicate values; The names of the tables are the same, the number of tables is the same, but there are unique values. How to make a third of two bases with a unique value of both bases? Thank!
- I am afraid I will have to do everything with my pens ... maybe my luck has not improved, but so far I have not come across a single more or less decent database merging tool. - Akina
- And if the request is correct to roll? Well, let's say, find the difference between the tables (without id - but, for example, on "column-2 after id"). This will go for unique values. Then requests for repetitions. Then both requests to work. I just have no idea how to turn this into phpmyadmin. What should be done? Import both databases, ok, then work out the queries described above and make INSERT? - forever_young
- Or, for example, just stupidly reduce two tables with one name and display unique values, then add the resulting values to db_3.tb? - forever_young
- Yes, to merge the data is garbage. SELECT INTO OUTFILE + LOAD DATA INFILE IGNORE. Problems will start when it is required not to lose foreign keys. And if it turns out that the texts of SP / UFD / triggers or the structure of the tables have spread out - so generally light the carcass. - Akina
|