单个语句都没有错。但是第二行 +起来后就不行。。这样子查询不可以吗? 那应该怎么写呢。谢谢大家啦。帮我看看。
$sql = "UPDATE a SET fen=
(select moneys from b where ddno=1 + select fen from a WHERE userID=(select userID from com_enewsshopdd where ddno=1))
WHERE userID=(select userID from b where ddno=1)";
$sql = "UPDATE a SET fen=
(select moneys from b where ddno=1 + select fen from a WHERE userID=(select userID from com_enewsshopdd where ddno=1))
WHERE userID=(select userID from b where ddno=1)";
UPDATE A,B SET A.value=B.value+A.value
WHERE A.id=B.id;
如三楼的
UPDATE A SET A.value=B.value+A.value FROM A,B
WHERE A.id=B.pid;