请问update更新字段值如何使用表达式

[hangge666]

row想用表达式 但是这样子不行，请问该怎么做

[jerryhu]

代码示例:

await this.app.mysql.update('post_comment', { id: commentId, replies: new Literal('(replies+1)') });

const updateOptions = [];
updateOptions.push({ id: postId, replies: new Literal(`(replies+${replyCount})`) });
await this.app.mysql.updateRows('post_comment', updateOptions);

@hangge666

[hangge666]

代码示例:

await this.app.mysql.update('post_comment', { id: commentId, replies: new Literal('(replies+1)') });

const updateOptions = [];
updateOptions.push({ id: postId, replies: new Literal(`(replies+${replyCount})`) });
await this.app.mysql.updateRows('post_comment', updateOptions);

@hangge666

学到了 ， 不过您是在哪里看到的呢？ 总之谢谢您了

[puzzle9]

代码示例:

await this.app.mysql.update('post_comment', { id: commentId, replies: new Literal('(replies+1)') });

const updateOptions = [];
updateOptions.push({ id: postId, replies: new Literal(`(replies+${replyCount})`) });
await this.app.mysql.updateRows('post_comment', updateOptions);

@hangge666

学到了 ， 不过您是在哪里看到的呢？ 总之谢谢您了

https://eggjs.org/en/tutorials/mysql.html#literal