Wednesday, April 6, 2011

Update table of two different database

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?

From stackoverflow
  • This link might help.

0 comments:

Post a Comment