Jan-03-2022, 01:54 PM
Hi, I want to add the data from the text file to the column named "firma" in sqlite. What should I do?
import sqlite3 vt = sqlite3.connect("AyGrupDatabase.sqlite") im = vt.cursor() im.execute("CREATE TABLE IF NOT EXISTS firma_giris (firma,kullanici,kod,sistem,isveren,araci)") dosya = open("sirket.txt","r",encoding="utf-8") for i in dosya: i=i[:-1] im.execute("INSERT INTO firma_giris(firma) values(?) ",(i)) vt.commit()