def sql(cadillac): #连接sqlite connection=sqlite3.connect("E:\esl-working-1.3.7_rc2-sp8\db.sqlite") cursor=connection.cursor() cursor.execute(cadillac) cursor.close() connection.commit() if __name__ == '__main__': n = 0 print ctime() + "正在进行更新,轮次:" + str(n) # while True: # time.sleep(10) # n = n +1 # # # conmysql("update") # conmysql("update hs_goods set price1 = ('"+str(n)+"')") # # conmysql("update hs_goods set price1 = 'str(n)'") while True: n = n +1 time.sleep(5) sql("update sales_list set Price = ('"+str(n)+"')")
python 操作数据库
最新推荐文章于 2023-08-26 08:55:03 发布