PHP-MySQL-How to safely increment MySQL integer field?

php mysql transactions counter
John picture John · Jan 9, 2010 · Viewed 48k times · Source

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

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

  2. Is there a minimum version of MySQL I must use?

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

Answer

Chris Tonkinson picture Chris Tonkinson · Jan 9, 2010

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

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 [...]

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.

Related questions

PHP + MySQL transactions examples

I really haven't found normal example of PHP file where MySQL transactions are being used. Can you show me simple example of that? And one more question. I've already done a lot of programming and didn't use transactions. Can I …

Read More
Codeigniter Transactions

I'm using Codeigniter transactions $this->db->trans_start(); $this->db->query('AN SQL QUERY...'); $this->db->trans_complete(); This works fine , the problem I have is that inside the trans_start and trans_…

Read More
Why does TRANSACTION / COMMIT improve performance so much with PHP/MySQL (InnoDB)?

I've been working with importing large CSV files of data; usually less than 100,000 records. I'm working with PHP and MySQL (InnoDB tables). I needed to use PHP to transform some fields and do some text processing prior to the MySQL …

Read More