我想用不同的数据库将数据从一个表更新到另一个表,而不需要在更新查询中设置所有列值。对于前任。更新company.employee SELECT*FROM organization.employe WHERE empid=225
方法一:
UPDATE
company.employee,
organisation.employee
SET
company.employee.firstname = organisation.employee.firstname
WHERE
organisation.employee.empid=225;
方法二:
INSERT INTO organisation.employee
SELECT * FROM company.employee
WHERE company.employee.empid=225;
你可以尝试一下,但是,没有足够的信息来确定你想要实现的目标。