UPDATE from SELECT using SQL Server, MYSQL

UPDATE
    geocoder,
    cellocator_historial
SET
    geocoder.GPSX = cellocator_historial.GPSX,
    geocoder.GPSY = cellocator_historial.GPSY

WHERE
    geocoder.idcellocator = cellocator_historial.idcellocator
    AND cellocator_historial.idcellocator BETWEEN 10 AND 10000 ;

UPDATE
    table_to_update,
    table_info
SET
    table_to_update.col1 = table_info.col1,
    table_to_update.col2 = table_info.col2

WHERE
    table_to_update.ID = table_info.ID

UPDATE business AS b
INNER JOIN business_geocode AS g ON b.business_id = g.business_id
SET b.mapx = g.latitude,
  b.mapy = g.longitude
WHERE  (b.mapx = '' or b.mapx = 0) and
  g.latitude > 0
UPDATE
   geocoder,
   cellocator
SET
   geocoder.idvehiculoestado="1"   
where cellocator.idcellocator =  geocoder.idcellocator 
AND cellocator.RMUId="564730" 
AND geocoder.idvehiculo= 26 
AND geocoder.CellDateTime > "2015-07-30 11:01:35"  
AND geocoder.CellDateTime <= "2016-04-29 18:24:12"   
AND cellocator.Speed >= "2"

UPDATE ubigeo AS distrito 
INNER JOIN ubigeo AS provincia ON provincia.codigo = concat(LEFT(distrito.codigo, 4),'00') AND provincia.tipo_ubigeo_id =  2 
INNER JOIN ubigeo AS departamento ON departamento.codigo = concat(LEFT(distrito.codigo, 2),'0000') AND departamento.tipo_ubigeo_id =  1 
SET 
distrito.descripcion =  CONCAT(distrito.ubigeo,', ' , provincia.ubigeo ,', ' ,departamento.ubigeo)
WHERE distrito.tipo_ubigeo_id = 3  ; 

referencia http://stackoverflow.com/questions/2334712/update-from-select-using-sql-server

Para Insert Into
INSERT INTO address (address.GPSX, address.GPSY)
SELECT  DISTINCT
ROUND(GPSX ,3) ,
ROUND(GPSY ,3)
 FROM geocoder
WHERE  (geocoder.address <> "" )  ;