Quick simple question I think...

Discussion in 'MySQL' started by dotCEO, Sep 18, 2009.

0
  1. #1
    I have a TABLE called FRUITS and I want to delete EVERYTHING inside a specific COLUM... For Example

    FRUITS Table has:

    Strawberries Bananas Apples Pineapples
    info Info info info
    info info info info
    (The formatting is gone... I hope someone understands tough..)
    I want to take all the info out of the column banana and leave everything else intact... how do I go about this? I use phpMyAdmin by the way

    Thanks
     
    dotCEO, Sep 18, 2009 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    UPDATE FRUITS SET Bananas = NULL;

    Or,

    UPDATE FRUITS SET Bananas = '';
     
    jestep, Sep 18, 2009 IP
  3. dotCEO

    dotCEO Member

    Messages:
    75
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    45
    #3
    ah dude, you're the man! thank you very much... sorry for my delay in gratitude..
     
    dotCEO, Sep 18, 2009 IP