MySQL关键字Distinct的详细介绍

create table test(id bigint not null primary key auto_increment,
   name varchar(10) not null,
   phone varchar(10) not null,
   email varchar(30) not null)engine=innodb;

 insert into test(name, phone, email)values('alibaba','0517','alibaba@alibaba.');
  insert into test(name, phone, email)values('alibaba','0517','alibaba@alibaba.');
  insert into test(name, phone, email)values('baidu','010','baidu@baidu.');
  insert into test(name, phone, email)values('tencent','0755','tencent@tencent.');
  insert into test(name, phone, email)values('shop','020','shop@shop.');
  insert into test(name, phone, email)values('ctrip','021','ctrip@ctrip.');
  insert into test(name, phone, email)values('suning','025','suning@suning.');