mysql如何去除数据表中的重复数据（How does MySQL remove duplicate data from a data table）.doc

mysql如何去除数据表中的重复数据（How does MySQL remove duplicate data from a data table） MySQL how to remove duplicate data in the data table.Txt10 is persistent, the lonely journey of life can be cast into a piece of blue sky; with perseverance, loneliness can become a row of Hongyan; with perseverance, joy can blossom into Manyuan flowers. Usually, a when we do a product, may start due to the design or inconsiderate program written is not rigorous, a field value is repeated, but it must be removed, this time a little a little trouble, directly add a UNIQUE KEY is not sure. Because the wrong. Now, lets adopt an alternative approach, but some data may be lost:) Here, we set up a table with the following structure: Mysql desc `user`; +-------+------------------+------+-----+---------+----------------+ Field Type Null | | | | Key | Default | Extra | +-------+------------------+------+-----+---------+----------------+ | | id int (10) unsigned NO PRI NULL | | | | auto_increment | | | name char (10) NO | | | | | | | extra char (10) NO | | | | | +-------+------------------+------+-----+---------+----------------+ The data in the original table assumes the following: Mysql SELECT * FROM `user`; +----+-------+--------+ ID name extra | | | | +----+-------+--------+ | 1 | user1 | user1 | | 2 | user2 | user2 | | 3 | user3 | user3 | | 4 | user4 | user4 | | 5 | user5 | user5 | | 6 | user3 | user6 | | 7 | user6 | user7 | | 8 | user2 | user8 | | 9 | USER2 | user9 | | 10 | USER6 | user10 | +----+-------+--------+ 1. Export the original data MysqlSELECT * INTO, OUTFILE,/tmp/user.txt, FROM, `user`; 2, empty the data table MysqlTRUNCATE TABLE `user`; 3, create a unique index, and modify the type of `name` field for BINARY CHAR, case sensitive Mysql, ALTER, TABLE, `user`, MODIFY, `name`, CHAR (10), BINARY, NOT, NULL, DEFAULT; Mysql, ALTER, TABLE, `user`, ADD, UNIQUE, KEY (`name`); Now take a look at the new table structure: Mysql desc user; +-------+------------------+------+-----+---------+--------