有懂SQL语句的帮金光整个法子

聶十八

哈哈.你们踢了那么久累不累啊?
+ O0 w- F  R6 ]; R2 E# \2 ]# l& ?会MYSQL语句的帮金光写个语句.然后好让他一次性查询出来

. Q+ E# d& w, N' c

& l3 l9 f0 \/ |& b& u  A6 Cselect ( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a.pid<b.pid order by pid) as xuhao, author, subject, message  from pre_forum_post as b where b.fid='863265' and b.tid='105' and first=0 and mod(( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a.pid<b.pid order by pid) ,25)=0

zyok

不懂·······

聶十八

select ( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a.pid<b.pid order by pid) as xuhao, author, count(*)  from pre_forum_post as b where b.fid='863265' and b.tid='105' and first=0 and mod(( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a.pid<b.pid order by pid) ,25)=0
5 r. W" M1 o* \6 W+ _( b
" N1 L4 q5 L: A( \2 h  G$ ?: D% r
4 {7 L3 f" g: C- x2 m这个只看发帖者.并显示踢中次数
7 m8 x+ @( Z6 V哈哈.MYSQL不会.真累
  R3 V8 ~, ^4 z! d3 ^2 d还是MSSQL比较容易懂

vica

, Y$ f4 ?( d: w! A; _( N. B& _- j
貌似只能按回复的pid排序，没有楼层数的字段。

zyok

高手········

聶十八

vica 发表于 2010-11-22 08:22

1 l" h; a* a9 C; s% g                               
登录/注册后可看大图

貌似只能按回复的pid排序，没有楼层数的字段。

哈哈。我就是按PID排序后再确定楼层的

三叶草

高手，mysql和mssql大体上是一致的，可能函数名不一样，或者mysql不支持太复杂的子查询

聶十八

mssql的话可以用
select distinct identity(int,1,1) ............ into
) ]/ h8 y  U* n/ t' u 来生成楼层数

金光

聶十八 发表于 2010-11-22 00:55

" H6 ~* c$ B& {& ^/ G9 h                               
登录/注册后可看大图

select ( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a. ...

MySQL 返回：

* n1 j8 Z4 D* m6 N( X#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
1 k" h) a( r9 s0 R; }# m5 d- Z
4 E, l, j" e# n# ]# Q

金光

聶十八 发表于 2010-11-22 00:51

& T, ?# L! C' C/ L5 v( w( W                               
登录/注册后可看大图

哈哈.你们踢了那么久累不累啊?
9 ]; k' y1 D# v( J  \  V会MYSQL语句的帮金光写个语句.然后好让他一次性查询出来

select ( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a.pid<b.pid order by pid) as xuhao, author, subject, message  from pre_forum_post as b where b.fid='863265' and b.tid='105' and first=0 and mod(( select count(*) as dd from pre_forum_post as a where  a.fid='863265' and a.tid='105' and a.pid<b.pid order by pid) ,25)=0