1update a inner join b on a.bid=b.id set a.x=b.x,a.y=b.y ;
UPDATE phome_ecms_live
SET filename = (
SELECT
CONCAT(aa.id, aa.filename)
FROM
(
SELECT
id,
filename
FROM
phome_ecms_live
) aa
)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024