謝晒的PHP網頁設計
聯絡E-mail:
sean0704@gmail.com
站內搜尋
Monday, June 3, 2013
[MySQL] 過濾重複的資料 (DISTINCT)
SELECT DISTINCT id FROM user
注意:
DISTINCT的原理是先做一次排序,然後再將重複值篩選掉,所以,對大型資料庫來說會很耗時。
No comments:
Post a Comment
Newer Post
Older Post
Home
View mobile version
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment