|
Posted by Rik on 02/16/07 15:45
On Fri, 16 Feb 2007 16:30:26 +0100, Brian <djswirl@remove_me_yahoo.com> =
=
wrote:
> Hi there
>
> I'm sure this can be done but not sure of the MSQL code
>
> I want to run an update statement on a field where it adds
> X to want ever is already in the field?
>
> e.g.
> field =3D 10
> Add =3D 5
> update field add 5 to field so field now =3D 15
> but if field was null then field now =3D 5
>
> Brian
UPDATE `table` SET `field` =3D `field` + 5
-- =
Rik Wasmus
Navigation:
[Reply to this message]
|