Tuesday, September 6, 2011

How to update rows across databases?


update db1.PERSON person,  db2.MAN man
set person.name = man.name
where
old_tab.id = man.id

No comments:

Post a Comment