Re: how i do a update in django QuerySet like this: update table t set col_a = col_a + 2 where col_b = 1

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> 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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.