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]