Friday, May 29, 2015

Using Mysql update values from one table to another table

UPDATE  `pqrs-es-developmentdb`.survey_entity_mapping
INNER JOIN  `pqrs-es-developmentdb`.survey ON (`pqrs-es-developmentdb`.survey_entity_mapping.surveyid = `pqrs-es-developmentdb`.survey.surveyid)
SET `pqrs-es-developmentdb`.survey_entity_mapping.year_id = `pqrs-es-developmentdb`.survey.survey_year_id