我有一个像下面这样的查询
UPDATE NOTIFICATION_MASTER
SET PARTICIPANT_COUNT = ? * LIKE_COUNT
+ ? * POST_COUNT
+ ? * VIEWS
WHERE ID = ?
AND CORP_ID = ?;
它会工作吗?
基本上是的,但是您的DBMS可能会要求您使用cast
指定类型,如... + cast(? as int) + cast(? as int) ...