sqlalchemy 增删改查

最新推荐文章于 2024-10-08 11:32:26 发布

m0_58364248

最新推荐文章于 2024-10-08 11:32:26 发布

阅读量275

点赞数

文章标签： python flask

本文链接：https://blog.csdn.net/m0_58364248/article/details/121900862

版权

#增
#查
#get(id)
s = Student.query.get(2)
print(s.name)

#all()
s = Student.query.all()
for i in s:
    print(i.name)

#filter()
s = Student.query.filter(Student.gender =="nan")
for i in s :
    print(i.name,i.gender)
#改
stu = Student.query.filter(Student.id==1).update({"name":"zhang"})
db.session.commit()

s = Student.query.filter(Student.gender=="nan").update({"gender":"zhang"})
db.session.commit()


#san