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

聶十八

哈哈.你们踢了那么久累不累啊?
会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

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
% S) p" w6 c9 O- S6 `: p

5 R. G# N6 n1 }# @$ G- H这个只看发帖者.并显示踢中次数
& Z! u+ m; d3 n# L- ?, J$ |哈哈.MYSQL不会.真累
还是MSSQL比较容易懂

vica

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

zyok

高手········

聶十八

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

                               
登录/注册后可看大图

/ j9 Q1 r) ^% o, z# C貌似只能按回复的pid排序，没有楼层数的字段。

* e* a. }0 K7 A* d) I# E' e哈哈。我就是按PID排序后再确定楼层的

三叶草

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

聶十八

mssql的话可以用
select distinct identity(int,1,1) ............ into
+ L7 t- |" Q  N% ?0 u 来生成楼层数

金光

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

/ b: z  n4 X  Z1 ]( n% t                               
登录/注册后可看大图

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

/ _0 i* v* b6 L4 N* iMySQL 返回：

#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

# @( X+ n% n& L! v; h                               
登录/注册后可看大图

5 D9 o9 R5 o: K' @, p. f5 x/ I  y哈哈.你们踢了那么久累不累啊?
会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