SELECT [欄位1,欄位2…] FROM [資料表名稱] WHERE [條件]
ORDER BY [排序欄位1,排序欄位2...] ASC/DESC
GROUP BY [群組欄位]
LIMIT 開始,筆數
例:查詢資料表member的全部資料,顯示account跟password欄位
SELECT account,password FROM member
例:查詢資料表member的全部資料,顯示全部欄位
SELECT * FROM member
例:查詢資料表member內account有abc及password是1234的資料,顯示全部欄位
SELECT * FROM member WHERE account='abc' AND password='1234'
例:查詢資料表member的全部資料, 依account遞增排序,顯示全部欄位
SELECT * FROM member ORDER BY account ASC
例:查詢資料表member的全部資料, 依account遞減排序,顯示全部欄位
SELECT * FROM member ORDER BY account DESC
例:查詢資料表member的全部資料, 依account為群組,顯示全部欄位
SELECT * FROM member GROUP BY account
例:查詢資料表member的0筆開始,顯示10筆, 顯示全部欄位
SELECT * FROM member LIMIT 0,10
留言列表