How can I search in a database using an integer id variable?

python python-3.x database sqlite tkinter

Use placeholder:

myCursor.execute("SELECT * FROM USER_DATA WHERE ID=?", (id_number.get(),))

python python-3.x database sqlite tkinter

Maybe using f strings could help.

myCursor.execute(f'SELECT*FROM USER_DATA WHERE ID={id_number.get()}')

CodeHunter