Home | 简体中文 | 繁体中文 | 杂文 | Github | 知乎专栏 | Facebook | Linkedin | Youtube | 打赏(Donations) | About
知乎专栏

第 25 章 SQL Statement Syntax

Structured Query Language

目录

25.1. DISTINCT
25.2. JOIN
25.2.1. LEFT JOIN / LEFT OUTER JOIN
25.2.2. JOIN / INNER JOIN
25.3. order by 排序
25.3.1. 处理 null
25.4. group by
25.4.1. 忽略 NULL
25.5. HAVING
25.6. REGEXP
25.7. IN / NOT IN
25.8. ALL / Any
25.9. exists, not exists
25.10. UNION
25.10.1. UNION ALL
25.10.2. 两张表字段不对等解决方法
25.11. OUTFILE/LOAD DATA INFILE
25.11.1. Export data to CSV from MySQL
25.11.2. Import data from CSV file.
25.12. CASE Syntax
25.13. 查询结果放入变量
25.14. MySQL 专有命令
25.14.1. SQL_NO_CACHE
25.14.2. SIGNAL Syntax
25.15. SQL 92

25.1. DISTINCT

SELECT DISTINCT user.name FROM user

SELECT DISTINCT user.name FROM user