On 12/16/2011 12:57 PM, richard terry wrote:
> Hope this question isn't too idiotic and makes sense.
>
>
> Is there a simple way to increment the value of an integer field in a table in
> sql without reading the fields value adding 1 and re-saving? (the field is not
> a primary key or any other sort of foreign key)
>
> regards
>
> richard
>
>
Try this
UPDATE tables SET inc=inc+1 WHERE key=ID;
--
Best regards
Aleksej Trofimov