第 6 章 SQL Statement Syntax
上一頁 部分 I. MySQL 下一頁
Home | Mirror | Search

第 6 章 SQL Statement Syntax

Structured Query Language

目錄

1. DISTINCT
2. group by
3. replace
4. OUTFILE/LOAD DATA INFILE
4.1. Export data to CSV from MySQL
5. SQL 92
6. Functions and Operators
6.1. COUNT
6.2. UUID()
6.3. String
6.3.1. LEFT/RIGHT
6.3.2. RPAD/LPAD
6.3.3. CONCAT
6.3.4. GROUP_CONCAT
6.3.5. replace
6.4. Date and Time
6.4.1. year/month/day hour:minite:second
6.4.2. Unix time
6.4.3. DATE_FORMAT
6.4.4. DATE_SUB
6.4.5. datediff / timediff
7. 事務處理和鎖定語句
7.1. 排他鎖
7.2. 表的加鎖與解鎖
7.3. 事務所用到的表
8. MySQL 專有命令
8.1. SQL_NO_CACHE

1. DISTINCT

SELECT DISTINCT user.name FROM user

SELECT DISTINCT user.name FROM user
comments powered by Disqus
上一頁 上一級 下一頁
7. Partitioning 起始頁 2. group by