假设F1为字段名
UPDATE A INNER JOIN
(SELECT * FROM B A1 WHRE NOT EXISTS(SELECT 1 FROM B WHERE DATE(F1)=DATE(A1.F1) AND A.F1<F1)) A2
ON DATE(A.F1)=DATE(A2.F1)
SET A.F1=B.F1
UPDATE A INNER JOIN
(SELECT * FROM B A1 WHRE NOT EXISTS(SELECT 1 FROM B WHERE DATE(F1)=DATE(A1.F1) AND A.F1<F1)) A2
ON DATE(A.F1)=DATE(A2.F1)
SET A.F1=B.F1
请问版主我这样写可以么?
update player_dynamic_info t1 inner join (select PlayerLevel,LogonTime,LogonIP from player_logonip t2 where t1.Datetime = date(t2.LogonTime) and t1.PlayerID = t2.PlayerID order by t2.LogonTime limit 1) set t1.PlayerLevel = t2.PlayerLevel,t1.LogonTime = t2.LogonTime,t1.LogonIP = t2.LogonIP请问这样写可以么
sorry 我知道我的哪里错了。