1 ALTER TABLE geoloc_subadministrativeareas
ADD COLUMN administrativearea
VARCHAR(255) DEFAULT NULL;
3 UPDATE geoloc_subadministrativeareas
AS gs
4 INNER JOIN profile_addresses
AS pa
ON (gs.
id = pa.subAdministrativeAreaId
)
5 SET gs.administrativearea
= pa.administrativeAreaId
;
7 -- vim:set syntax=mysql: