w3resource

Python: Insert values to a table from user input


7. Insert Values from User Input

Write a Python program to insert values to a table from user input.

Sample Solution:

Python Code :

import  sqlite3
conn  =  sqlite3 . connect ( 'mydatabase.db' )
cursor  =  conn.cursor ()
#create the salesman table 
cursor.execute("CREATE TABLE salesman(salesman_id n(5), name char(30), city char(35), commission decimal(7,2));")

s_id = input('Salesman ID:')
s_name = input('Name:')
s_city = input('City:')
s_commision = input('Commission:')
cursor.execute("""
INSERT INTO salesman(salesman_id, name, city, commission)
VALUES (?,?,?,?)
""", (s_id, s_name, s_city, s_commision))
conn.commit ()
print ( 'Data entered successfully.' )
conn . close ()
if (conn):
  conn.close()
  print("\nThe SQLite connection is closed.")

Sample Output:

Salesman ID: 5
Name: Jhon Edin
City: New York
Commission: 5
Data entered successfully.

The SQLite connection is closed.

For more Practice: Solve these Related Problems:

  • Write a Python program to create a SQLite table and then prompt the user to input values for a new record, which is then inserted into the table.
  • Write a Python function that collects user input for each field of a table, inserts the record, and then prints a confirmation message with the inserted data.
  • Write a Python script to continuously accept user input to add records to a SQLite table until the user types "exit", then print the total number of records inserted.
  • Write a Python program to prompt the user for record values, insert the record into a SQLite table, and then display all rows to confirm the insertion.

Go to:


Previous: Write a Python program to insert a list of records into a given SQLite table.
Next: Write a Python program to count the number of rows of a given SQLite table.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.