How to execute update query by applying join on two different tables in different databases on same server

update <dbname of 1st table>.<table name of 1st table> A INNER JOIN <dbname of 2nd table>.<table name of 2nd table> RA ON A.<field name of table 1>=RA.<field name of table 2> SET A.<field name of table 1 to be updated>=RA.<field name of table 2 to set value in table 1>


Replace data in < > with your appropriate values.

Thats It.
 

How to replace degree(°) with " & deg;" using php

$myvalue=" +1°C to +10°C";
$r=preg_replace("/\xB0/", '&deg;', $myvalue);

$myvalue will contain value that you want to replace.