Jump to content


This topic is now archived and is closed to further replies.


updating from another table.

Recommended Posts

I am trying to update a field from another table... and I can\'t seem to get the mysql syntax right...


com_no is my key field

record_no is the field I am trying to update


(I am trying this in phpmyadmin)



LEFT JOIN tbl2 ON tbl.com_no=tbl2.com_no;


update tbl

set tbl.record_no=\'7681\'

where tbl2.record_no = \'7686\';

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.