moneyslow.com

discuz 分组取第一个aid,并将宽度加1

选取第一个aid

select a.aid from pre_forum_attachment_9 a where width<>801 and aid=(select min(aid) from pre_forum_attachment_9 where tid=a.tid) order by a.tid;

批量将第一张图宽度加1

update pre_forum_attachment_9 set width=width+1 where aid in (234,23423,23423423,234234);

新贴将第一张图宽度加1

update pre_forum_attachment_0 set width=width+1 where filename='1.jpg' and tid > 466456;

update pre_forum_attachment_1 set width=width+1 where filename='1.jpg' and tid > 466456;
update pre_forum_attachment_2 set width=width+1 where filename='1.jpg' and tid > 466456;
update pre_forum_attachment_3 set width=width+1 where filename='1.jpg' and tid > 466456;
update pre_forum_attachment_4 set width=width+1 where filename='1.jpg' and tid > 466456;
update pre_forum_attachment_5 set width=width+1 where filename='1.jpg' and tid > 466456;
update pre_forum_attachment_6 set width=width+1 where filename='1.jpg' and tid > 466456;
update pre_forum_attachment_7 set width=width+1 where filename='1.jpg' and tid > 466456;
update pre_forum_attachment_8 set width=width+1 where filename='1.jpg' and tid > 466456;
update pre_forum_attachment_9 set width=width+1 where filename='1.jpg' and tid > 466456;

Exit mobile version