UPDATE user_bank a INNER JOIN bank AS b

ON a.bank_code = b.bank_code

SET 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';

聲明：本網(wǎng)頁(yè)內(nèi)容旨在傳播知識(shí)，若有侵權(quán)等問題請(qǐng)及時(shí)與本網(wǎng)聯(lián)系，我們將在第一時(shí)間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com