newid = select max(replyid) from bbs
update bbs set replyid = newid + 1 where id = 100不知道这两句能不能一句代替
试过update bbs set replyid = max(replyid) + 1 where id = 100
不行
update bbs set replyid = newid + 1 where id = 100不知道这两句能不能一句代替
试过update bbs set replyid = max(replyid) + 1 where id = 100
不行
replyid = (select max(replyid) from bbs) + 1
where id = 100
update bbs set
replyid = (select max(replyid) from bbs where id = 100) + 1