DELETE 
FROM
    test_table 
WHERE
    id IN ( SELECT id FROM test_table WHERE id_card_no = "51****59" AND id != 5 );

SELECT id FROM test_table WHERE id_card_no = "51****59" AND id != 5;             

def del_from_mysql():
    # 【讀取數(shù)據(jù)ID】
    with open(file="新建文本文檔.txt", mode="r", encoding="utf-8") as f:
        data = f.read()
        f.close()
    ids = data.split("\n")
    print(ids)
if __name__ == "__main__":
    del_from_mysql()

pip install pymysql

import pymysql
def del_from_mysql(dbinfo):
    # 【讀取數(shù)據(jù)ID】
    with open(file="新建文本文檔.txt", mode="r", encoding="utf-8") as f:
        data = f.read()
        f.close()
    ids = data.split("\n")
    # 【連接數(shù)據(jù)庫執(zhí)行SQL】
    conn = pymysql.connect(**dbinfo)
    cursor = conn.cursor()
    for i in ids:
        sql = f"delete from test_table where id={i}"
        cursor.execute(sql)
        conn.commit()
    conn.close()
if __name__ == "__main__":
    # 數(shù)據(jù)庫信息
    db_info = {
        'host': "192.168.1.1",
        'port': 3306,
        'user': "test",
        'passwd': "test",
        'db': "test_",
        'charset': "utf8"
    }
    del_from_mysql(db_info)

DELETE 
FROM
    test_table 
WHERE
    id IN ( SELECT * FROM ( SELECT id FROM test_table WHERE id_card_no = "51****59" AND id != 5 ) t1 );