Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002

    Red face Unanswered: Adding to a current record

    I am trying to add to a current record.
    I have this:
    Date Errors
    3-10-2003 10

    I want to add any additional Errors on this date to the current number of Errors. for instance if I had 5 more errors I would like this:
    Date Errors
    3-10-2003 15

    Can I do this in my sql statmant?

    Thanks for your help in advance!

  2. #2
    Join Date
    Sep 2002
    Provided Answers: 1

    Re: Adding to a current record

    You would use an UPDATE statement:

    UPDATE mytable
    SET errors = errors+5
    WHERE datecol = TO_DATE('03-10-2003','MM-DD-YYYY');

Posting Permissions

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