Update table of two different database
Posted
by chetan
on Stack Overflow
See other posts from Stack Overflow
or by chetan
Published on 2010-03-16T08:59:26Z
Indexed on
2010/03/16
9:06 UTC
Read the original article
Hit count: 189
This is the query to update table in one database that is of other
Update
test.temp a,
test2.temp b
Set a.name=b.name
Where a.no=b.no;
Now I don't want to write every field i.e a.name=b.name
Is there any solution?
© Stack Overflow or respective owner
