Update SQLite using Python using user input

Question

Hi I want to be able to update the income of a specific record using the user input to find it. I can't seem to figure it out. I can only update the database using the following code below. I'm new to programming- have looked in books and online and can't seem to find the solution.

What do I need to do to the code below to be able to do this.

import sqlite3
from sqlite3 import Connection

conn: Connection = sqlite3.connect('tax1.db')
c = conn.cursor()
c.execute("UPDATE tax SET income = 10000 WHERE customerID = 1")
conn.commit()

TessellatingHeckler · Accepted Answer · 2022-08-20 14:42:21Z

0

From this thread use a parameterised SQL query, e.g.

import sqlite3
from sqlite3 import Connection

customer_id = input("Enter the customer ID: ")
new_income  = input("Enter the income: ")

conn = sqlite3.connect('tax1.db')
c = conn.cursor()
c.execute("UPDATE tax SET income = ? WHERE customerID = ?",(new_income, customer_id))

See also this Python 3.9 documentation on the sqlite3 module which says:

use the DB-API’s parameter substitution. To insert a variable into a query string, use a placeholder in the string, and substitute the actual values into the query by providing them as a tuple of values to the second argument of the cursor’s execute() method. An SQL statement may use one of two kinds of placeholders: question marks (qmark style) or named placeholders (named style)

answered Aug 20, 2022 at 14:42

TessellatingHeckler

29.3k4 gold badges55 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Update SQLite using Python using user input

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related