Home >Database >Mysql Tutorial >mysql的多表关联更新怎么写?_MySQL

mysql的多表关联更新怎么写?_MySQL

WBOY
WBOYOriginal
2016-06-01 13:48:12957browse

bitsCN.com

Mysql 多表关联更新sql

 

 

UPDATE items,month SET items.price=month.price

WHERE items.id=month.id and 条件=条件 ;

bitsCN.com
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