Das deutsche Python-Forum

Code: Alles auswählen

sql = "INSERT INTO optionen VALUES ('test')"

    my_cursor.execute(sql)
    my_db.commit()

Code: Alles auswählen

brief=tk.Text()

Code: Alles auswählen

brief=tk.Text()
brief.pack()

sql = "INSERT INTO optionen VALUES (%s)"
    val = (brief.get)
    my_cursor.execute(sql, val)
    my_db.commit()

Code: Alles auswählen

def mtg_brief_speichern():
    with closing(my_db.cursor()) as cursor:
     cursor.execute("INSERT INTO optionen (brief) VALUES (%s)",[brief.get("1.0", "end")])
     my_db.commit()