So I thought I'd try transaction
BEGIN TRANSACTION;
UPDATE address
SET address.address = '103 greenock road'
FROM address a, location l
WHERE a.locationId = l.locationId
and l.locationId = '3';
COMMIT;
I'm getting the error message
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRANSACTION' at line 1
