code_junkie

Converting an Oracle merge query into mysql mySQL query

Nov 13th, 2011
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. MERGE INTO PAGEEDITCONTROL A
  2. USING (SELECT
  3. '1585' AS PAGEID
  4. ,'admin' AS EDITUSER
  5. ,sysdate AS EDITDATE
  6. FROM DUAL) B
  7. ON (A.PAGEID = B.PAGEID)
  8. WHEN MATCHED THEN
  9. UPDATE SET
  10. A.EDITUSER = B.EDITUSER
  11. ,A.EDITDATE = B.EDITDATE
  12. WHEN NOT MATCHED THEN
  13. INSERT (
  14. A.PAGEID
  15. ,A.EDITUSER
  16. ,A.EDITDATE
  17. )VALUES(
  18. B.PAGEID
  19. ,B.EDITUSER
  20. ,B.EDITDATE
  21. )
Add Comment
Please, Sign In to add comment