Mysqli绑定参数 - 更新语句 - 引用列+1

Question

I am wondering if mysqli works when binding a column reference +1 type of field. Example.

UPDATE `table` SET  `sys-helpful-yes` = `sys-helpful-yes`+1 WHERE `id` = 1;

When using mysqli bind parameters, it doesn't add the one.

UPDATE `table` SET  `sys-helpful-yes` = ? WHERE `id` = 1;

I am trying to bind

`sys-helpful-yes`+1

Wondering if anyone has a workaround.

Answer 1

What about

UPDATE `table` SET  `sys-helpful-yes` = `sys-helpful-yes`+ ? WHERE `id` = 1;

and then, of course, only bind 1 ... (not tested) ?