Python manage.py shell#进入SQL的shell
p=Publisher(id=2,name='Lee',address='C',city='C',country='C',state_province='C',website='https://www.baidu.com')
p.save()
Publisher.objects.filter(name='Lee') #相当于SQL的where
Publisher.objects.filter(name__contains='L')#相当于SQL的LIKE %like%
Publisher.objects.order_by("name")#SQL的order by
#连锁查询
Publisher.objects.filter(name='L').order_by('name') #where 和 order by的组合
Publisher.objects.order_by(name='L')[0]#相当于limit 1
Publisher.objects.order_by(name='L')[0::2]#相当于offset 0 limit 2
#错误示范
Publisher.objects.order_by(name='L')[-1] #错误,没有负索引
#更新对象
p=Publisher.objects.get(name='L')
p.name='Lee'
p.save()
publisher.objects.get(name='L').updat