DELETE FROM foo;
  INSERT INTO foo SELECT * FROM reference.foo;