你是要插入还是要更新啊 插入的话 insert into B select ST_GEOMETRY from A 更新的话 A与B表至少要有个字段相关联吧update B set ST_GEOMETRY=(select ST_GEOMETRY from A where A.id=B.id) where B.id in (SELECT id from A where A.id=B.id)
请参考:如果A表和B表有对应的主键列,且A表中有的记录在B表中没有 insert into B select * from A where A.主键=B.主键如果A表和B表有对应的主键列,且A表中有的记录在B表中已经有了,但B表ST_GEOMETRY列未赋值 update B set ST_GEOMETRY = (select ST_GEOMETRY from A where A.主键=B.主键
插入的话
insert into B select ST_GEOMETRY from A 更新的话
A与B表至少要有个字段相关联吧update B set ST_GEOMETRY=(select ST_GEOMETRY from A where A.id=B.id)
where B.id in (SELECT id from A where A.id=B.id)
insert into B
select * from A where A.主键=B.主键如果A表和B表有对应的主键列,且A表中有的记录在B表中已经有了,但B表ST_GEOMETRY列未赋值
update B set ST_GEOMETRY =
(select ST_GEOMETRY from A where A.主键=B.主键