Compara tabelas
SELECT * FROM t1 LEFT JOIN t2 ON t1.id = t2.id WHERE t2.id IS NULL
Copia Colunas
UPDATE tabela SET coluna1=coluna2 WHERE condicao=TRUE