This works by using UPDATE to iterate over the INNER JOIN.
DEFAULT Specifies that the default value defined for the column is to replace the existing value in the column.
If the item already exists, instead update the stock count of the existing item.
To do this without failing the entire transaction, use savepoints: BEGIN; -- other operations SAVEPOINT sp1; INSERT INTO wines VALUES('Chateau Lafite 2003', '24'); -- Assume the above fails because of a unique key violation, -- so now we issue these commands: ROLLBACK TO sp1; UPDATE wines SET stock = stock 24 WHERE winename = 'Chateau Lafite 2003'; -- continue with other operations, and eventually COMMIT; If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.
This can also be used to change the column to NULL if the column has no default and is defined to allow null values.
Compound assignment operator: = Add and assign -= Subtract and assign *= Multiply and assign /= Divide and assign %= Modulo and assign &= Bitwise AND and assign ^= Bitwise XOR and assign |= Bitwise OR and assign Returns updated data or expressions based on it as part of the UPDATE operation.