|
Тема |
Re: MySQL- bavno query [re: salle] |
|
Автор | x (Нерегистриран) | |
Публикувано | 03.04.03 17:34 |
|
|
SELECT COUNT(*) FROM docinfn WHERE word_id IN (1,2,3);
+----------+
| COUNT(*) |
+----------+
| 102499 |
+----------+
1 row in set (0.34 sec)
SELECT COUNT(*), COUNT(DISTINCT word_id), COUNT(DISTINCT cl0), COUNT(DISTINCT doc_id) FROM docinfn;
+----------+-------------------------+---------------------+------------------------+
| COUNT(*) | COUNT(DISTINCT word_id) | COUNT(DISTINCT cl0) | COUNT(DISTINCT doc_id) |
+----------+-------------------------+---------------------+------------------------+
| 26481240 | 802396 | 211999 | 200000 |
+----------+-------------------------+---------------------+------------------------+
1 row in set (18 min 45.17 sec)
|
| |
|
|
|