2 messages in com.mysql.lists.plusplusRE: Update, Insert.....Speed
FromSent OnAttachments
Mandy Llanes28 Nov 2007 07:01 
Jim Wallace28 Nov 2007 07:20 
Subject:RE: Update, Insert.....Speed
From:Jim Wallace (jwal@kaneva.com)
Date:11/28/2007 07:20:36 AM
List:com.mysql.lists.plusplus

I think this is what you're saying. If you want to insert a row if not there you can use MySQL's INSERT INTO..ON DUPLICATE KEY syntax.

http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

or REPLACE depending on what you're doing. Replace will delete and insert a row if it exists, the other doesn't.

http://dev.mysql.com/doc/refman/5.0/en/replace.html

-----Original Message----- From: Mandy Llanes [mailto:mand@serfiex.es] Sent: Wednesday, November 28, 2007 10:02 AM To: plus@lists.mysql.com Subject: Update, Insert.....Speed

Hello, If I'do Update an row in tables but my row not here return error. I want send SQL to server ... UPDATE table SET f1=v1, f2=v2 WHERE f0="v0" but this row is null that Insert this Row. That's possible? How?

Thank's Mandy.