站內搜尋

Wednesday, February 13, 2013

[MYSQL] 計算指定欄位中的資料筆數 "COUNT"


值為NULL的資料，並不會列入總筆數中

SELECT COUNT(email) FROM mytable

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)