Sql delete

Hello everyone!
I want to delete a row but with an ID from st.text_input
import sqlite3
import pandas as pd
import streamlit as st
conn = sqlite3.connect(‘my_data.db’)
c = conn.cursor()
row=st.text_input("Enter ID of the row: ")
c.execute(“DELETE from mutaciones where ID = row”)

but I have an error, may somebody help me please, regards

c.execute(f“DELETE from mutaciones where ID = ‘{row}’”)

Great many thanks!

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.