#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2012
    Posts
    24
    Rep Power
    0

    Partial deletion


    I would like to delete content from some but not all columns in a table record. Have tried set column = '' (two single quotes) and ' ' (space between single quotes). FB SQL is not happy with either approach. Would you please show me how to get this done.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2006
    Location
    Carlsbad, CA
    Posts
    2,057
    Rep Power
    383
    Column = Null
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2008
    Posts
    55
    Rep Power
    6

    Thumbs up


    For each type of column, one type content

    SO, if the COLUMN is type STRING

    update <table>
    set columnd_name = '' (OR NULL is is possible NULL content)
    where <<clausule_needed>>


IMN logo majestic logo threadwatch logo seochat tools logo