update 可以与left join 一起用吗?

WBOY
Release: 2016-06-20 12:38:05
Original
3649 people have browsed it

各位大神,我是这么写的,好像不对,能帮我改改吗?谢谢!
$query = "UPDATE a,b set a.sta = '3',b.scores='b.scores+a.pname' from `member_operation` WHERE aid = '$var'  as a left join  `member` as b on a.mid=b.mid ";

member_operation  WHERE aid = '$var表和member表通过 a.mid=b.mid相联。

我想使得member_operation 表中的sta = '3',member表中的scores等于原有值加上member_operation 中pname值。


回复讨论(解决方案)

有人教我一下吗?谢谢大神。。。

UPDATE a,b set a.sta = '3',b.scores='b.scores+a.pname' from `member_operation` WHERE aid = '$var'  as a left join  `member` as b on a.mid=b.mid
Copy after login
 

UPDATE a,b set a.sta = '3',b.scores='b.scores+a.pname'  from `member_operation` WHERE aid = '$var'  as a left join  `member` as b on a.mid=b.mid 

UPDATE a,b set a.sta = '3',b.scores='b.scores+a.pname' from `member_operation`  as a left join  `member` as b on a.mid=b.mid WHERE a.aid = '$var'   试试这句吧  看看符合你需求么。。

好的 ,我试试,谢谢~!

source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!