import MySQLdb import string db = MySQLdb.connect(host = "127.0.0.1", user = "root", db = "tests", charset = 'cp1251') cursor = db.cursor() f = open("C:\Project\log", "r") l = f.readline()[:-2] while l!="": s = (l[:-2], f.readline()[:-2], f.readline()[:-2], f.readline()[:-2], f.readline()[:-2]) s = str(s) sql = "INSERT INTO problems ('subject', 'number', 'question', 'answer', 'correct_answer') VALUES" + s cur.execute(sql) db.commit() f.readline() db.close() f.close()