using php/mysql to empty a row, and only a row?

Discussion in 'PHP' started by Crayz, Aug 6, 2006.

  1. #1
    Does anyone know how to do this? I want to empty a row, and only that row on the table. Nothing else, is there a way to do it besides the update and that other one, is there a command specifically made for clearing the whole row?
     
    Crayz, Aug 6, 2006 IP
  2. Klian

    Klian Member

    Messages:
    81
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    45
    #2
    I think that there isnt any command for clearing rows.

    Im not sure, but im interested too.
     
    Klian, Aug 7, 2006 IP
  3. TwistMyArm

    TwistMyArm Peon

    Messages:
    931
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    0
    #3
    None for clearing a row... there is DROP, but that is for deleting a row. In reality, if you are able to completely clear a row and still have it being valid, then your database schema is not very good. I mean, don't you at least have some sort of unique key in the row?
     
    TwistMyArm, Aug 7, 2006 IP
  4. rosytoes

    rosytoes Peon

    Messages:
    230
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #4
    What do you mean by empty a row?
    DELETE FROM <table name> ... is for deleting rows.
    DROP TABLE <table name> ... is for deleting a table.
     
    rosytoes, Aug 7, 2006 IP