I have a mysql query on an InnoDB table like this:

UPDATE items SET qty = qty + 5 WHERE item_id = 1234 LIMIT 1;

Do I need to use a transaction for this? Could anything undesirable happen by not using a transaction?

mysql transactions innodb
Edit
Report