自学教程：python-pymysql如何实现更新mysql表中任意字段数据

def Changehous():"""修改mysql里的任意字段数据"""    host = "localhost"#默认为localhost    user = "root"#用户名    passwd = "000000"#此处输入连接mysql的密码    port = "3306"#端口号可以不输入    database = "hous"#需要连接的数据库名(不是表名)    db = pymysql.connect(host, user, passwd, database)#连接mysql    cursor = db.cursor()#创建游标	#定义一个列表,来来装自己的字段名	#若字段名过多的话不建议使用这种方法    title = ['residential','house','area','orientation','floor','years','totalprice']    field = str(input("请输入要修改的字段名:"))#控制台输入    if field in title: #如果输入的字段名在title里面,那么就可以进行查询了.        name = str(input("请输入要修改的内容"))        id = int(input("请修改要更新内容的id:"))        if field == title[0]:            sql = "update mashine set residential='{}' where id='{}'".format(name,id)        elif field == title[1]:            sql = "update mashine set house='{}' where id='{}'".format(name, id)        elif field == title[2]:            sql = "update mashine set area='{}' where id='{}'".format(name, id)        elif field == title[3]:            sql = "update mashine set orientation='{}' where id='{}'".format(name, id)        elif field == title[4]:            sql = "update mashine set floor='{}' where id='{}'".format(name, id)        elif field == title[5]:            sql = "update mashine set years='{}' where id='{}'".format(name, id)        elif field == title[6]:            sql = "update mashine set totalprice='{}' where id='{}'".format(name, id)    else:        print("输入有误,没有查询到该字段!")    try:        cursor.execute(sql)        db.commit()#提交给数据库        print("修改成功")    except Exception as e:        print("修改失败")    finally:        db.close()#关闭数据库        cursor.close()#关闭游标

pip install mysql-connector

pip install PyMySQL