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,833
  • 5
  • 45
  • 53
chetan
  • 3,095
  • 20
  • 68
  • 111

0 Answers0