Re: INSERT record IF NOT EXISTS?

[Jasper Bryant-Greene]

Daevid Vincent wrote:
> Does mySQL have a way to INSERT a new record if one doesn't exist (based
> upon primary compound key)?
> 
> I see this "EXISTS" but not an example of how to use it with INSERT.
> 
> I see "INSERT... ON DUPLICATE KEY UPDATE col_name=expr" which is very close,
> but I want it to do nothing on duplicate key. :(

Why not just make the key unique? Then the insert won't work if the 
value already exists for that key.

Jasper