SHARE
TWEET

Untitled

a guest Feb 20th, 2019 72 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. $sql = "INSERT INTO fetss.ocs_extended(ocsID, internalNOTE)
  2.             VALUES('" .(int)$_POST['id'] ."', '". $db- >quote($_POST['note_desc']) ."')
  3.             ON DUPLICATE KEY UPDATE internalNOTE = VALUES('". $db->quote($_POST['note_desc']) ."')";
  4.    
  5. $sql = "INSERT INTO database.tablename(ID, Description)
  6. VALUES(ID, Description) on Duplicate Key Update Description = VALUES(Description)"
  7.    
  8. $sql = sprintf("INSERT INTO fetss.ocs_extended(`ocsID`, `internalNOTE`)
  9.                 VALUES(%d, '%s')
  10.                 ON DUPLICATE KEY UPDATE
  11.                 `internalNOTE` = VALUES(`internalNOTE`)",
  12.                 (int)$_POST['id'],
  13.                 $db->quote($_POST['note_desc']));
  14.    
  15. INSERT INTO foo (id, desc) VALUES(1, 'testing')
  16. ON DUPLICATE KEY UPDATE
  17. desc = 'some other string that is not testing';
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top