List:General Discussion« Previous MessageNext Message »
From:Brad Eacker Date:March 19 2004 10:59pm
Subject:Re: newbie: increment an existing record
View as plain text  
Jim <miasmo@stripped> writes:
>> It's likely he would prefer to update a particular record via
>>
>>     update t1 set f = f + 1 where id = 1234;
>>
>> Which will update only the record matching the id of 1234.
>
>That is indeed what I ended up doing, and it worked. Thanks.

Jim,
     It's good to hear that you were able to accomplish your
desired results.  Now if I could just figure out how to get a
job based upon the knowledge that I've built up over the last
decade of working with various RDBMS systems, coupled with over
9 years of web/back-end integration, and 13 years of Unix kernel
internal development experience.

     You may want to take a look at "Teach Yourself SQL in 21 Days"
by Stephens and Plew, Sams Publishing ISBN 0-672-31674-9 for the
copy that I have in front of me.  It does a good job of explaining
these kinds of questions.
                 Brad Eacker (beacker@stripped)


Thread
newbie: increment an existing recordmiasmo19 Mar
  • Re: newbie: increment an existing recordSasha Pachev19 Mar
Re: newbie: increment an existing recordbeacker19 Mar
  • Re: newbie: increment an existing recordmiasmo19 Mar
    • Re: newbie: increment an existing recordBrad Eacker19 Mar