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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]