本篇文章主要介绍了"django数据库基本操作增删改查"，主要涉及到方面的内容，对于web前端感兴趣的同学可以参考一下：
1、插入数据[python] view plain copy>>> from books.models import Publisher &...
1、插入数据
[python] view plain copy
>>> from books.models import Publisher
>>> p1 = Publisher(name='Apress', address='2855 Telegraph Avenue',
... city='Berkeley', state_province='CA', country='U.S.A.',
... website='http://www.apress.com/')
>>> p1.save()
2、查询
[python] view plain copy
>>> Publisher.objects.all()
[, ]
获取单个对象：
[python] view plain copy
>>> Publisher.objects.get(name="Apress")
如果结果是多个对象或者没有返回结果则会抛出异常
3、条件
筛选：
[python] view plain copy
>>> Publisher.objects.filter(name='Apress')
[]
[python] view plain copy
>>> Publisher.objects.filter(name__c
[]
__contains部分会被Django翻译成LIKE语句
排序：
[python] view plain copy
>>> Publisher.objects.order_by("name")
[, ]
相当于 order by name asc
[python] view plain copy
>>> Publisher.objects.order_by("-name")
加个负号相当于 order by name desc
限制返回数据：
[python] view plain copy
>>> Publisher.objects.order_by('name')[0]
相当于 limit 1
[python] view plain copy
>>> Publisher.objects.order_by('name')[0:2]
相当于 OFFSET 0 LIMIT 2
4、更新
[python] view plain copy
>>> Publisher.objects.filter(id=52).update(name='Apress Publishing')
[python] view plain copy
