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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to