Need some quick SQL help

Discussion in 'Site & Server Administration' started by filma, Apr 17, 2008.

0
  1. #1
    I need some quick SQL help, i'm hoping someone can help me.

    I have a table in my SQL database, in the table I've found a specific field, I want to edit the field, so that instead of having the field say "1" and sometimes it has "0" , I want it to have "0" for every item in the table.

    I don't know if anyone understood what I said, but I hope you do :) , does anyone know how to make a query for me to do that ? If so can you please pass it ? :D thanks ^^
     
    filma, Apr 17, 2008 IP
  2. Agent_Smith

    Agent_Smith Well-Known Member

    Messages:
    890
    Likes Received:
    43
    Best Answers:
    0
    Trophy Points:
    145
    #2
    phpmyadmin would be the easiest way to do this.

    Although, you can do it via a php file if you want, just that phpmyadmin takes seconds while the query takes a little longer.
     
    Agent_Smith, Apr 17, 2008 IP
  3. filma

    filma Well-Known Member

    Messages:
    494
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    140
    #3
    well I have Phpmyadmin (as that's how I browse my database) , but I don't see how I can do it. Can you please tell me :) ?
     
    filma, Apr 17, 2008 IP
  4. gate2vn

    gate2vn Peon

    Messages:
    809
    Likes Received:
    33
    Best Answers:
    1
    Trophy Points:
    0
    #4
    You should show the structure of table here first :)
     
    gate2vn, Apr 17, 2008 IP
  5. tanfwc

    tanfwc Peon

    Messages:
    579
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #5
    tanfwc, May 3, 2008 IP