Update data using join query in mysql

Question

The below query is working fine but not updating records in the database. In my database there is three records available for update, but it's not updating.

UPDATE vgm_details VD SET VD.job_id = ( select S.job_id from stuffings S JOIN vgm V ON S.booking_id = V.booking_id WHERE S.container_no = VD.container_no) where VD.job_id = 0;

i have attached screenshot of vgm_details table.

ScaisEdge · Accepted Answer · 2019-11-22 09:25:54Z

1

Instead of subquery (and related issue for scoping) You could use an update with join

UPDATE vgm_details VD 
INNER JOIN  stuffings  S ON S.container_no = VD.container_no
INNER JOIN vgm V  ON S.booking_id = V.booking_id 
SET VD.job_id = S.job_id 
WHERE VD.job_id = 0;

answered Nov 22, 2019 at 9:25

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update data using join query in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related