MySQL如何去除数据表中的重复数据.docVIP

í¨3￡?é????￡?ò????ò???ú×?ò???2ú?·μ?ê±oò￡?ò??aê??é?üóéóúéè??????2??ü?ò??3ìDòD′μ?2?1????÷￡??3??×???é?μ??μ2úéú???′á?￡?μ?ê?ó?±?D?è￥μ?￡??a??ê±oò?íé??￠?é·3á?ò?μ?￡??±?ó?óò??? UNIQUE KEY ???¨ê?2?DDá?￡?òò?a?ᱨ′í?￡ ???ú￡??ò??à′2éó?ò???±?í¨μ?°ì·¨￡?2?1y?é?ü?á?aê§ò?D?êy?Y :) ?ú?aà?￡??ò??éè?¨ò???±í￡????á11è???￡o 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 | | | | +-------+------------------+------+-----+---------+----------------+ ?-à′±í?Dμ?êy?Y?ù?¨óDò?????ì?￡o 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?￠???-à′μ?êy?Yμ?3? mysqlSELECT * INTO OUTFILE /tmp/user.txt FROM `user`; 2?￠????êy?Y±í mysqlTRUNCATE TABLE `user`; 3?￠′′?¨?¨ò??÷òy￡?2￠?òDT?? `name` ×???μ?ààDí?a BINARY CHAR ??·?′óD?D′ mysql ALTER TABLE `user` MODIFY `name` CHAR(10) BINARY NOT NULL DEFAULT ; mysql ALTER TABLE `user` ADD UNIQUE KEY ( `name` ); ???úà′?′?′D?μ?±í?á11￡o mysql desc user; +-------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | char(10) | NO | UNI | | | | extra | char(10) | NO | | | | +-------+------------------+------+