Re: merging tables

[Chad Bourque]

John,

You can add a unique index on the phone1 column. Then, you can do an insert into ... select ... on duplicate key update ... Or you can do an insert ignore ... In either case, just omit the primary key column and pretend the phone1 column is the primary key for the merge.

You could also do an insert select where you only select the rows from one table that aren't in the other table. You can do that by joining the tables or using an in subquery. The join will be faster.

HTH,
Chad