您好,请参考以下代码,如有帮助,还请采纳。
import pymysql
import pandas as pd
import os
# 请自行设置数据库参数
conn = pymysql.connect(host='xxx', port=3306, user='xxx', password='xxx', db='xxx', charset='utf8')
sql1 = "select * from old_file"
sql2 = "select * from new_file"
df1 = pd.read_sql(sql1, conn)
df2 = pd.read_sql(sql2, conn)
conn.close()
for f in df1.file.values:
if f in df2.file.values:
c1 = df1.loc[df1['file'] == f].loc[:, 'content'].values[0]
c2 = df2.loc[df2['file'] == f].loc[:, 'content'].values[0]
if c1 == c2:
pass
else:
s = "echo \"" + f + "\""
os.system(s)
else:
print("echo new_file not find this $" + f)