将新记录从一个数据库复制到另一个数据库的最佳方法

Question

whose structures are identical and which even have the same id's, now one of these databases collects information from a live feed, what i want to do is find a way to add just the new records to the second database so that the information can then be reviewed and managed, without disturbing the first database.

Is there an easy way to do this?

Answer 1

Depending on the size of your tables and whether or not you want to be selective about what you move from table1 to table2:

INSERT INTO table2 (field1,field2,field3)
SELECT field1,field2,field3 FROM table1

Should to the trick, add orders and where clauses etc as required!