> Assuming everything is properly indexed.
>
> (1) INSERT INTO my_table_1 (field1, field2) SELECT DISTINCT field1,
> field2 FROM my_table_2;
>
> or
>
> (2) INSERT IGNORE INTO my_table_1 (field1, field2) SELECT field1,
> field2 FROM my_table_2;
>
> Is there anything to say about this in a general
Assuming everything is properly indexed.
(1) INSERT INTO my_table_1 (field1, field2) SELECT DISTINCT field1,
field2 FROM my_table_2;
or
(2) INSERT IGNORE INTO my_table_1 (field1, field2) SELECT field1,
field2 FROM my_table_2;
Is there anything to say about this in a general sense, or does it al
Assuming everything is properly indexed.
(1) INSERT INTO my_table_1 (field1, field2) SELECT DISTINCT field1,
field2 FROM my_table_2;
or
(2) INSERT IGNORE INTO my_table_1 (field1, field2) SELECT field1,
field2 FROM my_table_2;
Is there anything to say about this in a general sense, or does it al