SQL Update statement syntax

Question

I have two tables which I want to update using an SQL Update statement. These two tables contains a row named "oak" and "exp" which is the values I want to update. My best guess so far is this:

'UPDATE `items_woods`, `skills_woodcutting` SET `oak`=`oak`+1, `exp`=`exp`+13 WHERE `id`=?'

However, none of the values are saved in the database. Thanks in advance.

UPDATE:

if ($stmt = $mysqli->prepare('

        BEGIN TRANSACTION

        UPDATE items_woods
        SET items_woods.oak = ´1´
        FROM items_woods T1, skills_woodcutting T2
        WHERE T1.id = T2.id 
        and T1.id = ´?´

        UPDATE skills_woodcutting
        SET skills_woodcutting.exp = ´1´
        FROM items_woods T1, skills_woodcutting T2
        WHERE T1.id = T2.id
        and T1.id = ´?´

        COMMIT


        ')) {

Answer 1

SQL Update, will only update one table at a time

Use a transaction with two update statements

Answer 2

As there two tables, you must update them with two separate statements. It is possible to make these a single transaction, and committing both transactions only after both are successful.

I'm not sure what datbase you are working with, but the general approach would be:

commit   (start the transaction)
update items_woods set oak = oak+1 where id = ?
update skills_woodcutting set exp=exp+13 where id = ?
commit   (complete the transaction)