Changing ALL values of 0 to 500,...just read it{I REALLY NEED HELP}

Discussion in 'Databases' started by Dextrone, Apr 5, 2007.

0
  1. #1
    Is there any way I can change all values of 0 IN A CERTAIN TABLE/DB to 500, is there a script, or a sql command.....any help.....
     
    Dextrone, Apr 5, 2007 IP
  2. SoKickIt

    SoKickIt Active Member

    Messages:
    305
    Likes Received:
    30
    Best Answers:
    0
    Trophy Points:
    70
    #2 
    UPDATE table_name SET field_name = 500 WHERE field_name = 0
    Code (markup):
     
    SoKickIt, Apr 5, 2007 IP
    Dextrone likes this.
  3. Dextrone

    Dextrone Peon

    Messages:
    680
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #3
    You Have Been Repped

    THANK YOU VERY MUCH
     
    Dextrone, Apr 5, 2007 IP