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\';
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.