Hello Andy, Friday, April 23, 2004, 12:59:28 PM, you wrote:
AF> Is there such a statement where, if the insert fails (due to a duplicate AF> record) an update will happen No, but you might want to look at REPLACE INTO to simulate this effect. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]