Technology Magazine – Php – Jquery – Html/csss – Design – Wordpress

Mysql Select Data From One Table Update To Other

++++++++++++++
+ 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;

Leave a comment for: "Mysql Select Data From One Table Update To Other"