"INSERT ... ON DUPLICATE KEY UPDATE" Syntax

"INSERT ... ON DUPLICATE KEY UPDATE" Syntax

Postby D630 » Tue Apr 16, 2013 3:32 am

Hi,

In "After Save" i run this code to modify a another table :

Code: Select all
$sql  = "INSERT INTO verbindung (";
$sql .= "formal_Erschliessung_ID)";
$sql .= "VALUES (";
$sql .= "'$recordID')";
nuRunQuery($sql);


This works fine. Now i would like to change it into a "INSERT ... ON DUPLICATE KEY UPDATE" Syntax, but i can not get at it. Can anybody give me a helping hand?

Thanks.
D630
 
Posts: 4
Joined: Fri Apr 12, 2013 7:30 pm

Re: "INSERT ... ON DUPLICATE KEY UPDATE" Syntax

Postby admin » Wed Apr 17, 2013 5:02 pm

admin
Site Admin
 
Posts: 3079
Joined: Mon Jun 15, 2009 9:53 am


Return to Custom Code