问下这个SQL的写法,该如何处理

WBOY

Release： 2016-06-13 12:37:26

Original

844 people have browsed it

问下这个SQL的写法

本帖最后由 u011669689 于 2013-09-25 18:25:00 编辑基础条件：
user表  userid ,username
user_money 表  u_id,user_money
user_money_exchange  表：money ,username,ordertag =1或2

现在想执行：

update user_money set user_money =  (user_money_exchange   当ordertag =1的 sum(money) + 当ordertag =2的 sum(money)） where  user_money.u_id = user.userid

<br />
update user_money <br />
set user_money.money = <br />
<br />
(select sum(ume.money) as m , u.userid from user_money_exchange ume  left join user u on ume.username = u.username where ume.ordertag = 1 group by ume.username<br />
 + <br />
select sum(ume.money) as m , u.userid from user_money_exchange ume  left join user u on ume.username = u.username where ume.ordertag = 2 group by ume.username) <br />
<br />
where user_money.u_id = u.userid<br />
<br />

Copy after login

这个是错的，想知道对的是？谢谢各位了

sql select update

Related labels：

Money nbsp user

source：php.cn

Previous article： php切换数据库的有关问题 Next article： kindeditor上传图片那里怎么去掉上传网络图片的功能

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