表关联更新:UPDATE user_bank a INNER JOIN bank AS bON a.bank_code = b.bank_codeSET a.bank_type =b.id WHERE a.bank_type IS NULL AND a.id=1650;更新前的查询：select * from user_bank where id = 1650;select * from user_bank where bank_type is null;select count(*) from user_bank where bank_type is null;select * from bank;select * from bank where bank_code = '03010000';