MYSQL教程MySQL关键字Distinct的详细介绍

作者：VEPHP 时间 2017-09-21

《MYSQL教程MySQL关键字Distinct的详细介绍》要点：
本文介绍了MYSQL教程MySQL关键字Distinct的详细介绍，希望对您有用。如果有疑问，可以联系我们。

MYSQL入门MySQL关键字Distinct用法介绍

MYSQL入门DDL

MYSQL入门Prepare SQL：

MYSQL入门
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;

MYSQL入门Prepare Data：

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

MYSQL入门查询数据如下图所示：

MYSQL入门ヨョ版? title=