If you have an indexed column in Table-A, than you can use the
"REPLACE" command. If the item is already in Table-A, it will overwrite
it. If not, it will work like the INSERT command.
Steve
At 03:36 PM 4/29/2002, Oswaldo Castro wrote:
>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
---------------------------------------------------------------------
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
