I want an On Duplicate Key do nothing feature which obviously doesn't
exist. However, will this be any faster than actually updating the row.
INSERT INTO table (a,b) VALUES (1,2)
ON DUPLICATE KEY UPDATE b=b;
BTW each row is made up of only 2 columns and those to columns make up
the key so if there is a duplicate key the record I am trying to insert
is already there exactly as I am attempting to insert....
--
Chris W
KE5GIX
Gift Giving Made Easy
Get the gifts you want &
give the gifts they want
One stop wish list for any gift,
from anywhere, for any occasion!
http://thewishzone.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]