thanks, it works
在 2012年11月20日星期二UTC+8下午11时09分23秒，Tom Evans写道：
>
> On Tue, Nov 20, 2012 at 1:00 PM, peixinchen <shan...@gmail.com<javascript:>>
> 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 view this discussion on the web visit
https://groups.google.com/d/msg/django-users/-/bYjIECs-32YJ.
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.
