def Changehous():
"""
修改mysql里的任意字段數(shù)據(jù)
"""
    host = "localhost"#默認(rèn)為localhost
    user = "root"#用戶(hù)名
    passwd = "000000"#此處輸入連接mysql的密碼
    port = "3306"#端口號(hào)可以不輸入
    database = "hous"#需要連接的數(shù)據(jù)庫(kù)名(不是表名)
    db = pymysql.connect(host, user, passwd, database)#連接mysql
    cursor = db.cursor()#創(chuàng)建游標(biāo)
	#定義一個(gè)列表,來(lái)來(lái)裝自己的字段名
	#若字段名過(guò)多的話(huà)不建議使用這種方法
    title = ['residential','house','area','orientation','floor','years','totalprice']
    field = str(input("請(qǐng)輸入要修改的字段名:"))#控制臺(tái)輸入
    if field in title: #如果輸入的字段名在title里面,那么就可以進(jìn)行查詢(xún)了.
        name = str(input("請(qǐng)輸入要修改的內(nèi)容"))
        id = int(input("請(qǐng)修改要更新內(nèi)容的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("輸入有誤,沒(méi)有查詢(xún)到該字段!")
    try:
        cursor.execute(sql)
        db.commit()#提交給數(shù)據(jù)庫(kù)
        print("修改成功")
    except Exception as e:
        print("修改失敗")
    finally:
        db.close()#關(guān)閉數(shù)據(jù)庫(kù)
        cursor.close()#關(guān)閉游標(biāo)

pip install mysql-connector

pip install PyMySQL