On Tue, Nov 20, 2012 at 1:00 PM, peixinchen <shangt...@gmail.com> wrote:
> how i do a update in django QuerySet like this: update table t set col_a =
> col_a + 2 where col_b = 1,
>
> i could use filter take the place of "where clause", but how "set col_a =
> col_a + 2" to being?
>
from django.db.models import F
Foo.objects.filter(col_b=1).update(col_a=F('col_a')+2)
https://docs.djangoproject.com/en/1.4/topics/db/queries/#query-expressions
Cheers
Tom
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
