distinct的用来获取数据库中不重复的记录值。
如下:
(1)创建数据库table idandname
CREATE TABLE idandname
(
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(10) NOT NULL,
PRIMARY KEY(id)
);
INSERT INTO idandname(name) VALUES('a');
INSERT INTO idandname(name) VALUES('b');
INSERT INTO idandname(name) VALUES('c');
INSERT INTO idandname(name) VALUES('c');
INSERT INTO idandname(name) VALUES('b');
select * from idandname;
+----+------+
| id | name |
+----+------+
| 1 | a |
| 2 | b |
| 5 | b |
| 3 | c |
| 4 | c |
+----+------+
(2)运行distinct获取不重复的记录值
select distinct name from idandname;
+------+
| name |
+------+
| a |
| b |
| c |
+------+
3 rows in set (0.00 sec)
最终获取到了3个不同的值,distinct name获取的就是不同的name信息。