python中mysql的增删改查
程序员文章站
2022-05-30 12:28:51
...
1、增加数据
import pymysql
db = pymysql.connect('localhost','root','123456','jing_dong')
cursor = db.cursor()
sql = """insert into student(name,age,sex,score) values('xiaoming',20,'1',85)
#开启事务
db.begin()
try:
cursor.execute(sql)
#提交到数据库,增删改需要提交
db.commit
print('insert success')
except pymysql.err.IntegrityError as e:
print(e)
#回滚
db.rollback()
#关闭游标,和数据库的连接
cursor.close()
db.close()
2、查询数据
import pymysql
db = pymysql.connect('localhost','root','123456','jing_dong')
cursor = db.cursor()
#查询id>1的人
sql = "select * from student where id>1"
cursor.execute(sql)
resultt = cursor.fetchall()
print(result)
3、删除数据
import pymysql
db = pymysql.connect("localhost","root","123456","jing_dong")
cursor = db.cursor()
#删除id为1的人
sql = "delete from student where id=1"
cursor.execute(sql)
db.commit
4、更新数据
import pymysql
db = pymysql.connect("localhost","root","1837467ljlj..","stu")
cursor = db.cursor()
sql = "update student set score=100 where score=85"
try:
cursor = cursor.execute(sql)
db.commit
except pymysql.Error as e:
print(e)
db.rollback()
cursor.close()
db.close()
上一篇: XML2-DTD(文档类型定义)
下一篇: 怕汤撒我身上