Need help using a PySimpleGUI TABLE with Sqlite3
Here is a small example to delete a row from table
import sqlite3def deleteRecord(): try: sqliteConnection = sqlite3.connect('SQLite_Python.db') cursor = sqliteConnection.cursor() print("Connected to SQLite") # Deleting single record now sql_delete_query = """DELETE from SqliteDb_developers where id = 6""" cursor.execute(sql_delete_query) sqliteConnection.commit() print("Record deleted successfully ") cursor.close() except sqlite3.Error as error: print("Failed to delete record from sqlite table", error) finally: if (sqliteConnection): sqliteConnection.close() print("the sqlite connection is closed")deleteRecord()
In your case id
will me the name of any column name which has unique
value for every row in thetable
of the database