[mythtv-users] Possibly OT: Merging Tables, NO duplicates.

[R. G. Newbury]

Brad DerManouelian wrote:
> On Nov 10, 2008, at 2:30 PM, R. G. Newbury wrote:
>
>> Is this the way to do it, or am I missing something really easy,  
>> such as
>> a horribly complex 'select....join' statement. Note that the schema of
>> all of these tables is exactly the same.
> 
> Take a look at REPLACE INTO to see if that helps you. It basically  
> acts as an INSERT unless it finds a duplicate primary key and them  
> simply updates that row with the new values.

I knew I could rely on this list! Thanks Brad.

Answer number one, nice and straightforward, not even a complex select.

I like it.

Geoff