List:General Discussion« Previous MessageNext Message »
From:Admin-Stress Date:November 6 2003 6:30pm
Subject:Simple question about updating a table field
View as plain text  
I have a numeric table field, named "CREDIT".
How can I add a number (+50) to that field for all the table record ?

is this correct?

   UPDATE ThisTable SET CREDIT=CREDIT+50

Please help,

Thanks

__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
Thread
INNODB flush holdupNihal5 Nov
  • Re: INNODB flush holdupMatt W6 Nov
    • RE: INNODB flush holdupNihal6 Nov
      • Re: INNODB flush holdupJeremy Zawodny6 Nov
        • RE: INNODB flush holdupNihal6 Nov
        • Table CreationArnoldus Th.J. Koeleman6 Nov
          • Re: Table CreationChris Boget6 Nov
          • Re: Table CreationDan Nelson6 Nov
          • Simple question about updating a table fieldAdmin-Stress6 Nov
            • Re: Simple question about updating a table fieldgerald_clark6 Nov