count_distinct3.result
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:0k
源码类别:
MySQL数据库
开发平台:
Visual C++
- DROP TABLE IF EXISTS t1, t2;
- CREATE TABLE t1 (id INTEGER, grp TINYINT, id_rev INTEGER);
- SELECT COUNT(*) FROM t1;
- COUNT(*)
- 4181000
- SELECT COUNT(DISTINCT id) FROM t1 GROUP BY grp;
- DROP TABLE t1;
- set @@read_buffer_size=default;