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

聶十八

哈哈.你们踢了那么久累不累啊?
会MYSQL语句的帮金光写个语句.然后好让他一次性查询出来
- x3 H7 B' {# R6 u& ~

. ~+ |1 ~+ T7 M9 G8 c5 W: n0 _
/ H" R1 [3 C1 D& D9 Kselect ( 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
9 D6 j; k& Y. k: I; E
& S: n- y, h7 q$ m* \
1 |: U! \8 C4 w8 R8 T这个只看发帖者.并显示踢中次数
哈哈.MYSQL不会.真累
还是MSSQL比较容易懂

vica

) I1 v! V/ z. f( z9 l
) {' i; u3 {; J1 i貌似只能按回复的pid排序，没有楼层数的字段。

zyok

高手········

聶十八

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

                               
登录/注册后可看大图

8 A4 O/ \5 G$ J貌似只能按回复的pid排序，没有楼层数的字段。

9 p/ c% y/ Z$ U3 m5 R哈哈。我就是按PID排序后再确定楼层的

三叶草

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

聶十八

mssql的话可以用
6 k/ h8 z- ]& ^! Sselect distinct identity(int,1,1) ............ into
来生成楼层数

金光

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

1 E: t& A! b7 _5 F1 c3 Z% j2 B4 M                               
登录/注册后可看大图

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

MySQL 返回：

3 E6 E8 K4 d6 J  y$ R#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

金光

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

                               
登录/注册后可看大图

哈哈.你们踢了那么久累不累啊?
3 n8 v8 {. P' E8 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