Question

Mysql复制一个字段到另个表，要求id相同

Answer 1

update
archives
a
set
xl=(select
xl
from
shop
b
where
b.aid=a.id
and
rownum
=
1)
where
a.id
in(select
id
from
archives)