All pastes #480249 Raw Edit

Miscellany

public text v1 · immutable
·published 2007-05-10 05:24 UTC
rendered paste body
  INSERT INTO FOO 
  .... 
  ON DUPLICATE KEY UPDATE
  FOO.COL_A = NOW() + FOO.COL_B 

  WHERE COL_B is '01:00:00'