Home > database >  Mysql table much more fields delete duplicate rows consult a great god!
Mysql table much more fields delete duplicate rows consult a great god!

Time:10-14

Mysql now there are 10 tables, each table has more than one thousand ten thousand lines
Table named
Pro0
Pro1
.
Pro6
Pro7
Pro10
Now want to send this form 10 A B C field duplicate rows deleted at the same time, the ten tables to keep only one row
A and B field established the general index,
Excuse me to how to deal with, through the Internet, didn't find a good way to merge table, feeling the last bulk handling fixed

CodePudding user response:

If the processing of the whole, still processing to it? To merge table billed in more than one hundred million,
  • Related