Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2007
    Location
    010101010110100
    Posts
    803

    Unanswered: Any opinions on ON DUPLICATE KEY UPDATE?

    ON DUPLICATE KEY UPDATE

    I know this isn't standard SQL but can anyone give me some advice on whether to use this or not? It's tempting because of its convenience.

    I am wondering if it falls along the same lines as never using the "dreaded evil enum"?


  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    not even close to that

    go ahead and use it, it is simpler than not having it available

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2007
    Location
    010101010110100
    Posts
    803
    That's Great News. Thanks Rudy!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •