SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE first_table ( id int, count int ); INSERT INTO first_table VALUES (1,10); CREATE TABLE second_table ( id int, total_count int ); INSERT INTO second_table VALUES (1,10); UPDATE first_table, second_table SET first_table.count = first_table.count + second_table.total_count, second_table.total_count = 0 WHERE second_table.id = 1 AND first_table.id = second_table.id; SELECT * FROM first_table; SELECT * FROM second_table; UPDATE second_table SET total_count = 5 WHERE id = 1; UPDATE first_table JOIN second_table ON first_table.id = second_table.id SET first_table.count = first_table.count + second_table.total_count, second_table.total_count = 0 WHERE second_table.id = 1; SELECT * FROM first_table; SELECT * FROM second_table;