Home >Database >Mysql Tutorial >mysql的sql经典写法收录_MySQL

mysql的sql经典写法收录_MySQL

WBOY
WBOYOriginal
2016-05-27 13:46:211058browse

表关联更新:

 

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn