Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 5th, 2012  |  syntax: None  |  size: 0.96 KB  |  hits: 11  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. On Duplicate Key Update - Multiple Columns
  2. INSERT INTO table1 (col1, col2, col3, col4) VALUES (’$val1’, ‘$val2’, ‘$val3’, ‘$val4’)
  3.     ON DUPLICATE KEY UPDATE col2=‘$val2’, col3=‘$val3’, col4=‘$val4’ // <-- not sure
  4.        
  5. $result = mysql_query("INSERT INTO table1 (col1, col2, col3, col4)
  6.                          VALUES (’$val1’, ‘$val2’, ‘$val3’, ‘$val4’)
  7.                          ON DUPLICATE KEY UPDATE (col2=‘$val2’, col3=‘$val3’, col4=‘$val4’)")
  8.        
  9. INSERT INTO table1 (‘col1‘, ‘col2‘, ‘col3‘, ‘col4‘) VALUES ('$val1', '$val2', '$val3', '$val4')
  10.     ON DUPLICATE KEY UPDATE ‘col2‘='$val2', ‘col3‘='$val3', [...]
  11.        
  12. INSERT INTO Stat (id, month, year, views, redirects, onList, onMap, emails) VALUE ("' . $Id . '","' . $month . '","' . $year . '",0,0,"' . $data['onList'] . '","' . $data['onMap'] . '",0) ON DUPLICATE KEY UPDATE onList=onList+' . $data['onList'] . ', onMap=onMap+' . $data['onMap']
create a new version of this paste RAW Paste Data