Hi List 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.
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 afterward Is there any other and better (more fast) way to do this? Please any help will be very, very appreciated. Greetings Oswaldo Castro --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
