def sql_cunchu(dict): conn = psycopg2.connect(database="mapwayonline", user="postgres", password="C02SP70YGF1J", host="47.92.116.107", port="5434") cur = conn.cursor() # cur.execute("select * from bjzs_big_data.baoji_company_top") # rows = cur.fetchall() # for row in rows: # print(row[0])
for key in dict.keys(): #cur.execute("INSERT INTO bjzs_big_data.baoji_company_top (name,index) VALUES (%s,%s)",(key, dict[key]))
#UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值 cur.execute("UPDATE bjzs_big_data.baoji_company_top SET isworld = %s WHERE name = %s and index = %s", (1 ,key, dict[key])) conn.commit() cur.close() conn.close()
posted on
2019-01-07 17:04袁佳佳
阅读(104)
评论(0)
编辑收藏举报