python中mysql的增删改查

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()