mysql distinct注意点

distinct是按照后面所有的字段为维度，去重

mysql> SELECT * FROM test_y;
+--------+------+------+---------------------+
| rec_id | y_id | yy   | created             |
+--------+------+------+---------------------+
|      1 |    2 | a    | 2016-10-18 15:59:06 |
|      2 |    3 | b    | 2016-10-18 15:59:16 |
|      3 |    1 | 2    | 2016-10-18 17:05:00 |
|      4 |    1 | 2    | 2016-10-19 17:05:00 |
|      5 |    1 | 2    | 2016-10-20 17:05:00 |
|     10 |    2 | 3    | 2016-10-26 15:15:09 |
|    193 |    1 | 2    | 2016-10-21 17:05:00 |
+--------+------+------+---------------------+
7 rows in set (0.00 sec)

mysql> SELECT  DISTINCT yy FROM test_y ;
+------+
| yy   |
+------+
| a    |
| b    |
| 2    |
| 3    |
+------+
4 rows in set (0.00 sec)

7 rows in set (0.00 sec)

mysql> SELECT  DISTINCT rec_id FROM test_y ;
+--------+
| rec_id |
+--------+
|      3 |
|      4 |
|      5 |
|    193 |
|      1 |
|     10 |
|      2 |
+--------+

mysql> SELECT  DISTINCT yy,rec_id FROM test_y ;
+------+--------+
| yy   | rec_id |
+------+--------+
| a    |      1 |
| b    |      2 |
| 2    |      3 |
| 2    |      4 |
| 2    |      5 |
| 3    |     10 |
| 2    |    193 |
+------+--------+
7 rows in set (0.00 sec)

mysql> SELECT  DISTINCT rec_id,yy FROM test_y ;
+--------+------+
| rec_id | yy   |
+--------+------+
|      1 | a    |
|      2 | b    |
|      3 | 2    |
|      4 | 2    |
|      5 | 2    |
|     10 | 3    |
|    193 | 2    |
+--------+------+
7 rows in set (0.00 sec)