mysqlクエリー編
563 ワード
2.
update user u
inner join user uu
on u.id=uu.idset u.number1=uu.number;
3. A B
update user u
inner join user u
uon u.id=uu.id
set u.number1=(u.number1+uu.number);
4. B A
UPDATE ultrax_forum_thread threadSET replies =
(SELECT count(1)
FROM ultrax_forum_post post
#WHERE tid =thread.tid
andwhere first=0and
dateline=1425225600group by tid
)
UPDATE ultrax_forum_thread thread
SET replies = 1
where thread.tid in
(
SELECT distinct tid
FROM ultrax_forum_post post
where first=0and dateline=1425225600
)