At 17:36 -0300 4/29/02, Oswaldo Castro wrote:
>I have two tables inside a MySQL DB. The first one has 30 Millions records
>(30.000.000) say it Table-A . The second one has 500 Thousands Records
>(500.000) say it Table_B. I need that all the records from Table-B to be
>inserted in Table-A. Because an operator error many of the records from
>Table-B is already present at Table-A but not all of them.
Use INSERT IGNORE.
>I think I can do two things
>1 - Delete Table-B from Table-A where key-B = key-A and after that, insert
>all Table-B into Table-A
>2 - Create an intermediary table say it Table-C that has all the records
>from the Table-B not present at the Table-A and insert that Table-C
>Is there any other and better (more fast) way to do this?
>Please any help will be very, very appreciated.