查找数据库中的重复记录(多个字段):SELECT * FROM wcs_best_fitness_individual WHERE (spokeCounts,isSpokeClosure,deflectionAngleOne,deflectionAngleTwo) IN (SELECT spokeCounts,isSpokeClosure,deflectionAngleOne,deflectionAngleTwo FROM wcs_best_fitness_individual GROUP BY spokeCounts,isSpok...【阅读全文】
1.将选中的数据快儿拷贝到一个TXT文本文件中或保存为csv文件(记得把后面的空格消掉。。)2.建立MySql数据库和表,然后进入命令提示符里使用命令load data local infile '~/data.txt' into table exceltomysql fields terminated by '\t';(如果要设置编码的话需要在fields前面加 character set utf8)...【阅读全文】