In navicat for mysql to import the new data, if there is the field date number, work number (business project business name production team note
) all of the content inside is not import (insert) if one of them is not the same as before you can import (insert) tried to joint the only index, but didn't succeed, give a great god a navicat for mysql using the detailed solution, thank you

CodePudding user response:

After import to weight a bit faster, or the guide for the test, to export again after heavy import

CodePudding user response:

Mysql import, no heavy before import Settings;
Proposal:
1, the entire amount of import, the only index to remove;
2, the new table structure on the id;
3, according to the id delete duplicate data; Refer to the following SQL (DELETE the FROM a ` game_table ` a
The JOIN (SELECT id FROM game_table GROUP BY TYPE HAVING a COUNT (1) & gt; 1) b
WHERE Anderson, d=b.i d)
4, new unique index;