1.先安装pymysql:cmd控制台输入指令pip install pymysql
import pymysql
# 建立mysql管道
db = pymysql.connect(host="127.0.0.1", user="root", password="root", database="school")
# 创建游标对象
cursor = db.cursor()
# 删除
# deleteStr = 'delete from student where Sid=20 or Sid=21'
# cursor.execute(deleteStr)
# 修改:如果表没有设置主键会报错:1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
# updateStr = "update student set Sname = '牛魔王' where Sid = 21"
# cursor.execute(updateStr)
# 新增
# insertStr = "insert into student values (20, '钟馗', 6)"
# cursor.execute(insertStr)
# 查询
selectStr = 'select * from student'
cursor.execute(selectStr)
# 获取结果
res = cursor.fetchall()
print(res)
for res_item in res:
print(res_item)
# 提交事务,如果执行增加、删除、修改操作不提交事务,数据就不会真的改动也就是操作失败
# db.commit()
# 关闭连接
db.close()