用2条语句;
或者这样44:
update testtable a set a.fid=(select max(b.fid) from testtable b) where a.fid=2;
或者这样44:
update testtable a set a.fid=(select max(b.fid) from testtable b) where a.fid=2;
调试欢乐多
update test a set a.msgid=(select max(b.msgid) from test b) where a.msgid=2;
这样也不行。
SET testtable.FID=A.MAX_ID Where testtable.fid=2;