ä¸è¬æ
åµä¸ï¼Select Count (*)åSelect Count(1)两çè¿åç»ææ¯ä¸æ ·ç
åå¦è¡¨æ²¡æ主é®(Primary key), é£ä¹count(1)æ¯count(*)å¿«ï¼
å¦ææ主é®çè¯ï¼é£ä¸»é®ä½ä¸ºcountçæ¡ä»¶æ¶åcount(主é®)æå¿«
å¦æä½ ç表åªæä¸ä¸ªå段çè¯é£count(*)å°±æ¯æå¿«ç
count(*) è· count(1) çç»æä¸æ ·ï¼é½å
æ¬å¯¹NULLçç»è®¡ï¼ècount(column) æ¯ä¸å
æ¬NULLçç»è®¡
1ãselect 1 ä¸ select *çåºå«
selelct 常é from ... 对åºææè¡ï¼è¿åçæ°¸è¿åªæä¸ä¸ªå¼ï¼å³å¸¸éãæ以æ£å¸¸åªä¼ç¨æ¥å¤ææ¯å¦æè¿æ¯æ²¡æï¼æ¯å¦existsåå¥ï¼ãèselect * from ... æ¯è¿åææè¡çææåã
æ§è½ä¸çå·®å¼ï¼å
³é®çä½ çfromåwhereåå¥ãæ¯å¦è¯´å¦æä½ çwhereæ¡ä»¶ä¸å¯ä»¥éè¿ç´¢å¼ï¼é£æ¾ç¶ select 1 from ... çæ§è½æ¯ select * from ... 好ã
2ãselect sum(1)ç使ç¨
select count(*)è¿åææ满足æ¡ä»¶çè®°å½æ°ï¼æ¤æ¶åselect sum(1)
ä½æ¯sum()å¯ä»¥ä¼ ä»»ææ°åï¼è´æ°ãæµ®ç¹æ°é½å¯ä»¥ï¼è¿åçå¼æ¯ä¼ å
¥å¼n*满足æ¡ä»¶è®°å½æ°m
温馨提示:答案为网友推荐,仅供参考