You can use replace into, but note it cannot do Replace into table VALUES (1,2,3,col4+1);
> -----Original Message----- > From: Andy Ford [mailto:[EMAIL PROTECTED] > Sent: Friday, April 23, 2004 3:59 AM > To: [EMAIL PROTECTED] > Subject: update if insert fails > > Hi > > Is there such a statement where, if the insert fails (due to a duplicate > record) an update will happen > > Thanks > > Andy > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]