PHP-MySQL-如何安全地增加MySQL整数字段? [英] PHP-MySQL-How to safely increment MySQL integer field?

问题描述

我想使用php和mysql安全地增加字段值.

I want to increment a field value safely using php and mysql.

1. 我必须使用哪种类型的表/字段?

1. What type of table/field must I use?

我必须使用最低版本的MySQL吗?

Is there a minimum version of MySQL I must use?

MySQL的这种安全交易的sql代码是什么?

What's the sql code for this, safe transaction for MySQL?

推荐答案

我假设您所说的表"是存储引擎.任何支持突变的内容(即不存档"或黑洞")

By what type of "table" I assume you mean storage engine. Anything that supports mutations (i.e. not "archive" or "black hole")

任何数字字段都可以(tinyint，int，float等).也就是说，没有特殊的PHP代码，只有用于增加所需字段的SQL:

Any numeric field will do (tinyint, int, float, etc). That said, there's no special PHP code, just the SQL for incrementing the desired field:

UPDATE table SET field = field + 1 WHERE [...]

如果要进行交易，则将以上查询打包到交易中.至于MySQL版本，我同意@hsz-尽可能使用最新版本.

If you want a transaction, then pack the above query into a transaction. As for MySQL version, I agree with @hsz - use the most current version possible.

这篇关于PHP-MySQL-如何安全地增加MySQL整数字段?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！