disuz数据库查询问题

Question

由于我这边没DISCUZ 数据库的表结构，而且事情也急。所以向大家求救需求是这样的： 在某个时间 给发帖量超过100的人 颁发一个勋章只是求一个SQL 语句，或者求DISCUZ 数据库的表结构谢谢了 版本是6.1的 事情很急，

Answer 1

这个简单，你可以直接到DISCUZ下载其免费的版本，然后你就可以了解其表结构了。

Answer 2

   建议你列出你的表结构，并提供测试数据以及基于这些测试数据的所对应正确结果。
   参考一下这个贴子的提问方式http://topic.csdn.net/u/20091130/20/8343ee6a-417c-4c2d-9415-fa46604a00cf.html
   
   1. 你的 create table xxx .. 语句
   2. 你的 insert into xxx ... 语句
   3. 结果是什么样，（并给以简单的算法描述）
   4. 你用的数据库名称和版本(经常有人在MS SQL server版问 MySQL)
   
   这样想帮你的人可以直接搭建和你相同的环境，并在给出方案前进行测试，避免文字描述理解上的误差。   

Answer 3

count(*) 一下 再having >100

Answer 4

select user
from tb
where rowdate between '' and ''
group by user 
having count(*)>100

Answer 5

---在某个时间 给发帖量超过100的人 颁发一个勋章
select user from tb
where date bewteen '' and ''
group by having count(*)>100

Answer 6

我大致看了下DISCUZ7.2的表，应该是在你的库的members表中，其中“cdb_”是你建立DISCUZ时设定的表前缀。但不确定，也不知道那个是勋章字段。
mysql> desc cdb_members;
+---------------+-----------------------+------+-----+------------+----------------+
| Field         | Type                  | Null | Key | Default    | Extra          |
+---------------+-----------------------+------+-----+------------+----------------+
| uid           | mediumint(8) unsigned | NO   | PRI | NULL       | auto_increment |
| username      | char(15)              | NO   | UNI |            |                |
| password      | char(32)              | NO   |     |            |                |
| secques       | char(8)               | NO   |     |            |                |
| gender        | tinyint(1)            | NO   |     | 0          |                |
| adminid       | tinyint(1)            | NO   |     | 0          |                |
| groupid       | smallint(6) unsigned  | NO   | MUL | 0          |                |
| groupexpiry   | int(10) unsigned      | NO   |     | 0          |                |
| extgroupids   | char(20)              | NO   |     |            |                |
| regip         | char(15)              | NO   |     |            |                |
| regdate       | int(10) unsigned      | NO   |     | 0          |                |
| lastip        | char(15)              | NO   |     |            |                |
| lastvisit     | int(10) unsigned      | NO   |     | 0          |                |
| lastactivity  | int(10) unsigned      | NO   |     | 0          |                |
| lastpost      | int(10) unsigned      | NO   |     | 0          |                |
| posts         | mediumint(8) unsigned | NO   |     | 0          |                |
| threads       | mediumint(8) unsigned | NO   |     | 0          |                |
| digestposts   | smallint(6) unsigned  | NO   |     | 0          |                |
| oltime        | smallint(6) unsigned  | NO   |     | 0          |                |
| pageviews     | mediumint(8) unsigned | NO   |     | 0          |                |
| credits       | int(10)               | NO   |     | 0          |                |
| extcredits1   | int(10)               | NO   |     | 0          |                |
| extcredits2   | int(10)               | NO   |     | 0          |                |
| extcredits3   | int(10)               | NO   |     | 0          |                |
| extcredits4   | int(10)               | NO   |     | 0          |                |
| extcredits5   | int(10)               | NO   |     | 0          |                |
| extcredits6   | int(10)               | NO   |     | 0          |                |
| extcredits7   | int(10)               | NO   |     | 0          |                |
| extcredits8   | int(10)               | NO   |     | 0          |                |
| email         | char(40)              | NO   | MUL |            |                |
| bday          | date                  | NO   |     | 0000-00-00 |                |
| sigstatus     | tinyint(1)            | NO   |     | 0          |                |
| tpp           | tinyint(3) unsigned   | NO   |     | 0          |                |
| ppp           | tinyint(3) unsigned   | NO   |     | 0          |                |
| styleid       | smallint(6) unsigned  | NO   |     | 0          |                |
| dateformat    | tinyint(1)            | NO   |     | 0          |                |
| timeformat    | tinyint(1)            | NO   |     | 0          |                |
| pmsound       | tinyint(1)            | NO   |     | 0          |                |
| showemail     | tinyint(1)            | NO   |     | 0          |                |
| newsletter    | tinyint(1)            | NO   |     | 0          |                |
| invisible     | tinyint(1)            | NO   |     | 0          |                |
| timeoffset    | char(4)               | NO   |     |            |                |
| prompt        | tinyint(1)            | NO   |     | 0          |                |
| accessmasks   | tinyint(1)            | NO   |     | 0          |                |
| editormode    | tinyint(1) unsigned   | NO   |     | 2          |                |
| customshow    | tinyint(1) unsigned   | NO   |     | 26         |                |
| xspacestatus  | tinyint(1)            | NO   |     | 0          |                |
| customaddfeed | tinyint(1)            | NO   |     | 0          |                |
| newbietaskid  | smallint(6) unsigned  | NO   |     | 0          |                |
+---------------+-----------------------+------+-----+------------+----------------+
49 rows in set
目前只能先给你查看用户名和发帖量的语句，然后你手动添加勋章。
select username,posts from 你的库.表前缀members ;
如：
select username,posts from discuz.cdb_members ;你应该说出你用的是哪个discuz，哪个版本。