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

[peixinchen]

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?


-- 
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/-/sA3EewkTS1EJ.
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.

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

[peixinchen]

thanks, it works

在 2012年11月20日星期二UTC+8下午11时09分23秒，Tom Evans写道：
>
> On Tue, Nov 20, 2012 at 1:00 PM, peixinchen > 
> 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.

django mysql charset settings

[peixinchen]

my MySQL variables like this:
| character_set_client | latin1
| character_set_connection | latin1   
| character_set_database   | utf8   

How can i set in django could make character_set_client and 
character_set_connection to 'UTF-8'?

I could using MySQLdb like this MySQLdb.connect(..., charset="utf-8").


-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.