replace.sql

CREATE TABLE report (
account_id INT UNIQUE,
classification VARCHAR(11)
);

CREATE TABLE report_temp (
account_id INT UNIQUE,
classification VARCHAR(11)
);

INSERT INTO report (account_id, classification) VALUES (1, "report");
INSERT INTO report (account_id, classification) VALUES (2, "report");
INSERT INTO report (account_id, classification) VALUES (3, "report");
INSERT INTO report (account_id, classification) VALUES (4, "report");
INSERT INTO report (account_id, classification) VALUES (5, "report");
INSERT INTO report (account_id, classification) VALUES (6, "report");
INSERT INTO report (account_id, classification) VALUES (7, "report");
INSERT INTO report (account_id, classification) VALUES (8, "report");
INSERT INTO report (account_id, classification) VALUES (9, "report");
INSERT INTO report (account_id, classification) VALUES (10, "report");

INSERT INTO report_temp (account_id, classification) VALUES (1, "report_temp");
INSERT INTO report_temp (account_id, classification) VALUES (3, "report_temp");
INSERT INTO report_temp (account_id, classification) VALUES (5, "report_temp");
INSERT INTO report_temp (account_id, classification) VALUES (7, "report_temp");
INSERT INTO report_temp (account_id, classification) VALUES (9, "report_temp");
INSERT INTO report_temp (account_id, classification) VALUES (11, "report_temp");
INSERT INTO report_temp (account_id, classification) VALUES (12, "report_temp");
INSERT INTO report_temp (account_id, classification) VALUES (13, "report_temp");

REPLACE INTO report_temp
SELECT report.* FROM report
INNER JOIN report_temp 
WHERE report.account_id = report_temp.account_id;

results.csv