How To Remove A Value From A Row In A Table?

Discussion in 'Databases' started by rrn, Mar 16, 2009.

0
  1. #1
    Hi ,

    my database is SQL..

    i have got a table with fields
    id name last name city
    3 xxx eee tvm
    4 mmm rrt ekm

    i know the query to delete an entire row from the table..
    but my problem is
    in the first row there should be no last name . ie 'eee' should be removed..
    is it possible???pls advice me with the query if any..

    thank you...
     
    rrn, Mar 16, 2009 IP
  2. mywebwork

    mywebwork Guest

    Messages:
    26
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I assume you know the ID number for the row?

    Bill
     
    mywebwork, Mar 17, 2009 IP
  3. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #3
    update table set name = '' where value = 'eee'
     
    crivion, Mar 17, 2009 IP
  4. rrn

    rrn Peon

    Messages:
    54
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Thanks a lot...to both mywebwork nd crivion..

    it worked ... i was stuck up with that..

    thank u.........
     
    rrn, Mar 17, 2009 IP