1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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