update A a , B b
set a.companyid=b.id where a.companyname=b.name and a.companyid=''
注意 查询的条件要放在后边,否则会报不是更新表的错 table is not uptable
update A a , B b
set a.companyid=b.id where a.companyname=b.name and a.companyid=''
注意 查询的条件要放在后边,否则会报不是更新表的错 table is not uptable