Question

    MERGE INTO PAGEEDITCONTROL A
      USING (SELECT
               1585  AS PAGEID
       , admin  AS EDITUSER
       ,sysdate AS EDITDATE
          FROM DUAL) B
      ON (A.PAGEID = B.PAGEID)
      WHEN MATCHED THEN
      UPDATE SET
      A.EDITUSER = B.EDITUSER
     ,A.EDITDATE = B.EDITDATE
      WHEN NOT MATCHED THEN
   INSERT  (
      A.PAGEID
     ,A.EDITUSER
     ,A.EDITDATE
      )VALUES(
      B.PAGEID
     ,B.EDITUSER
     ,B.EDITDATE
      )

Answer 1

INSERT INTO  
pageeditcontrol (pageid, edituser, editdate) 
VALUES  ( 1585 ,  admin , sysdate()) 
ON DUPLICATE KEY UPDATE 
edituser = values(edituser), 
editdate = values(editdate);

Answer 2

MySQL 有一个类似的结构，看起来不像更新插入，而更像插入: INSERT ... ON DUPLICATE KEY UPDATE（请参阅 MySQL 参考手册）。

友情链接