mysql批量update死锁,因为提交太多,所以每隔100条commit一下就可以解决了,特此纪念!
print("update started........")
if df_new.shape[0]>0:
for index,row in df_new.iterrows():
i += 1
print(i)
#print(f"正在更新{row['shop_code']}")
sql = f'''
update shop set sale_month='{row['sale_month']}'
,score_month='{row['score_month']}'
,update_time='{row['update_time']}'
,city='{row['city2']}'
,area='{row['shop_district2']}'
where shop_code='{row['shop_code']}'
'''
cur_test.execute(sql)
if i%100 == 0:
conn_test.commit()
print(f"{i} commit ok!")
conn_test.commit()
print(f"Updated {df_new.shape[0]} Rows!")