Question

我读过其他几个问题, 包括加入SQL最新消息,

系统都在 MySQL (INNODB 表格结构) 中

我们希望在一个表格中更新一个数额,该数额将根据另一个表格的2个变量增加一个数额。在更新中需要检查一些制约因素,以确保第二个表格的变量与要更新的表格的密钥匹配。

UPDATE as1
SET as1.amount = as1.amount + (b1.workers * b1.level)
FROM account_stock AS as1
INNER JOIN building AS b1 ON as1.accountID = b1.accountID
INNER JOIN building_seed AS bs1 ON bs1.buildingID = b1.buildingID
WHERE bs1.stockID = as1.stockID
AND b1.accountID = as1.accountID
AND b1.locID = as1.locID
AND b1.status = active
AND b1.gTime > 0

它出错了,我无法选择它。对不起,如果这是一个简单的问题,我所有的SQL都是自学的,所以我的一些习惯不是很好!

Answer 1

的 MySQL 语法“http://dev.mysql.com/doc/refman/5.5/en/update.html” rel=“nofollow”\\code>UPDATE 不同。没有 FROM :

UPDATE 
    account_stock AS as1
  INNER JOIN building AS b1 ON as1.accountID = b1.accountID
  INNER JOIN building_seed AS bs1 ON bs1.buildingID = b1.buildingID

SET as1.amount = as1.amount + (b1.workers * b1.level)

WHERE bs1.stockID = as1.stockID
  AND b1.locID = as1.locID
  AND b1.status = active
  AND b1.gTime > 0 ;

  --- removed duplicate : 
  --- AND b1.accountID = as1.accountID

还有: active 是专栏还是您要写入的? : AND b1. status= active

友情链接