Mysql Select Data From One Table Update To Other

An article by admin    No Comments

++++++++++++++
+ Website_cv
++++++++++++++
+ cv_id
+ status
++++++++++++++

+++++++++++++++
+ Website_apply_job
+++++++++++++++
+ cv_id
+ status
+++++++++++++++
=> copy Status From website_cv to website_apply_job

UPDATE website_apply_job
JOIN website_cv
ON website_cv.cv_id = website_apply_job.cv_id
SET website_apply_job.STATUS = website_cv.STATUS;