实战自学python如何成为大佬(目录):https://blog.csdn.net/weixin-67859959/artic

import pymysql # 打开数据库连接 db = pymysql.connect("localhost", "root", "root", "mrsoft",charset="utf8") # 使用cursor()方法获取操作游标 cursor = db.cursor() try: # 执行SQL语句，插入多条数据 cursor.execute("delete from books where category = 'PHP' ") # 提交数据 db.commit() except: # 发生错误时回滚 db.rollback() # 执行SQL语句，查询数据 cursor.execute("select name,price from books") # 获取查询结果: result = cursor.fetchall() for book in result : print("图书：《{name}》, 价格：￥{price}元".format(name=book[0], price=book[1])) # 关闭数据库连接 db.close()