Re: Add 15% to column?

[Michael Stassen]

Subscriptions wrote:

I have a decimal field in my table... what would be the query to add 15%
to that number in every row? I need to mark the column up by 15% and want to
make sure I get the query right the first time. heh

Jenifer

  UPDATE your_table
  SET decimal_field = 1.15 * decimal_field;

Michael

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