2

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?

Juan Mellado
  • 14,973
  • 5
  • 47
  • 54
chetan
  • 3,175
  • 20
  • 72
  • 113

0 Answers0