insert update mysql query example

insert into site_banners ( content_id )
select content_id from content on DUPLICATE key update site_banners.content_id = site_banners.content_id ;

gets all the keys from content table and inserts them into site_banners. if the key exist, basically, do nothing.