我一直在嘗試創(chuàng)建一個(gè)數(shù)據(jù)庫(kù)，我的表的列名來(lái)自一個(gè)列表：import sqlite3L = ["Nom","Age","Taille"]list2 = ["Karl", "11", "185"]M = []R = 0con = sqlite3.connect(":memory:")con.execute("CREATE TABLE master ("+",".join(L)+")")然后要么：for e in L: R += 1 con.execute("INSERT INTO master("+",".join(L)+") VALUES (?,?,?)",list2[R-1])或者for e in L: R += 1 con.execute("INSERT INTO master(e) VALUES (?)",list2[R-1])或者listX=[list2[0],list2[1],list2[3])con.executemany("INSERT INTO master ("+",".join(L)+") VALUES ("+",".join(M)+")", (listX))
從變量插入 sqlite3
www說(shuō)
2023-10-25 10:59:21
