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
Hello.
If you have some unique identifier, you can simply use
REPLACE INTO Table_B SELECT FROM Table_A;
But be sure to read and _understand_ the manual section about REPLACE
beforehand! Else, if you have not the required unique indexes, the
result will not be what you want.
INSERT INGORE would
At 17:36 -0300 4/29/02, 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-
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 fro
