Jump to content

Archived

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

Fritz

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.