[(['00:00:00', '445.011'], '20190329'), (['00:00:01', '965.649'], '20190329'), (['00:00:02', '461.963'], '20190329'), (['00:00:03', '492.741'], '20190329')
Код
with open('20190329.txt', 'r') as f: content=[s.split() for s in f] #a, b=zip(*content) #print(a); print(b) ccc = f.name print(ccc) ds = os.path.splitext(ccc)[0] cd = list (zip(content, itertools.repeat(ds))) print(cd) bd = type(content) print(bd) conn = MySQLdb.connect() cursor = conn.cursor() stmt = "INSERT INTO Vaza (Time, Nom, Date) VALUES (%s, %s, %s)" cursor.executemany(stmt, cd) conn.commit() conn.close()