On 15/06/2005 11:22 a.m., Kevin Burton wrote:
Simon Garner wrote:

I'm not entirely clear what you're talking about, but you could also have a look at INSERT IGNORE..., or INSERT... ON DUPLICATE KEY UPDATE, or REPLACE INTO...:



The problem is that I do NOT want it to update.
Also.. REPLACE causes the row to be DELETED and INSERTED again which is really ugly.

I just want to take one SELECT and INSERT pair and reduce it to one INSERT which should be 2x faster :)

Kevin


Then you want INSERT IGNORE :)

-Simon

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to