Results 1 to 2 of 2

Thread: Delete Data

  1. #1
    Join Date
    Apr 2012
    Posts
    12

    Thumbs up Unanswered: Delete Data

    Hi, Please, I want to be able to delete data in some fields in my database without deleting the fields. Your help will be deeply appreciated. Thanks.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ?
    do you mean effectively restting the value of (some) columns to a null or a default value?
    if so then use update
    eg
    Code:
    update mytable set acolumn = NULL,anothercolumn = 0, a stringcolumn = ''
    WHERE yetanothercolumn = 'blah'
    the where clause must be used otherwise the update statement will affect every row in the table
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •