UPDATE to current value?

Discussion in 'MySQL' started by Tony Brar, Nov 24, 2012.

  1. #1
    Hi guys,

    I want to know, does mysql have a problem if you update a value in the db to its current value?
    Will it just ignore or overwrite?

    Thanks,
    -Tony
     
    Tony Brar, Nov 24, 2012 IP
  2. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #2
    It has no problem. Whether it will ignore or overwrite is the kind of thing most SQL programmers don't worry about - the db engine is a black box. We give it certain input and it gives us certain output. How it does that might even change from version to version. We don't care. That sort of thing only comes in if you're the one writing the code for the engine.
     
    Rukbat, Nov 25, 2012 IP
  3. Tony Brar

    Tony Brar Active Member

    Messages:
    220
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    75
    #3
    Okay, just wanted to know if it would output an error.

    Thanks,
    -Tony
     
    Tony Brar, Nov 26, 2012 IP