Mysql数据操作指南(增删改查)

一、QuerySet 查询集:

1、QuerySet 查询集方法：all()：相当于SQL: "select * from UserBaseInfo;"

queryset = UserBaseInfo.object.filter(sex=1)  # 创建查询集
for user in queryset:                                     # 遍历迭代数据
    print(user.username)

　　

2、QuerySet 查询集方法：filter()：相当于SQL: "select * from UserBaseInfo where sex=1;"

queryset = UserBaseInfo.object.filter(sex=1)  # 创建查询集
for user in queryset:                         # 遍历迭代数据
    print(user.username)

3、QuerySet 查询集方法：get()：相当于SQL: "select * from UserBaseInfo where id=1;"

queryset = UserBaseInfo.object.get(id=1)  # 创建查询集
for user in queryset:                     # 遍历迭代数据
    print(user.username)

4、QuerySet 查询集方法：exclude()：相当于SQL: "select * from UserBaseInfo where age>31;"

queryset = UserBaseInfo.object.exclude(age__lt=31)  # 创建查询集
for user in queryset:                               # 遍历迭代数据
    print(user.username)

5、QuerySet 查询集方法：values()：相当于SQL: "select id,username from UserBaseInfo where id=1;"

queryset = UserBaseInfo.object.values("id","username")  # 创建查询集
for user in queryset:                     # 遍历迭代数据
    print(user.username)

6、QuerySet 查询集方法：distinct()去重复：相当于SQL: "select distinct department from UserBaseInfo where id=1;" 去重复部门

queryset = UserBaseInfo.object.distinct().values(“department”)  # 创建查询集
for user in queryset:                     # 遍历迭代数据
    print(user.username)

 

二、新增数据

1、save() :相当于SQL: "insert into department ("departname","createdate") values("技术部","2025-08-14 21:03:35.02515")

depart = DepartInfo()
depart.departname="技术部"
depart.createdate=timezone.now()
depart.save()

2、create() :相当于SQL: "insert into department ("departname","createdate") values("技术部","2025-08-14 21:03:35.02515")

depart = DepartInfo.object.create(departname="技术部",createdate=timezone.now())

三、更新数据：save(),update()

# save()
depart = DepartInfo.object.get(id=3)
depart.departname="技术部"
depart.save()
# update()
depart = DepartInfo.object.get(id=3).update(depart.departname="技术部")

四、删除数据：delete()

depart = DepateInfo.objects.get(id=1)
depart.delete()