Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sqlite3
- connection = sqlite3.connect("people")
- cur = connection.cursor()
- while True:
- first_name = input("Please enter first name:")
- if len(first_name) < 1: break
- last_name = input("Please enter last name:")
- age = input("Please insert age")
- try:
- age = int(age)
- except:
- break
- occupation = input("Please inster occupation:")
- cur.execute("INSERT INTO people (first_name, last_name, age, occupation) VALUES ('%s', '%s', %d, '%s')" % (first_name, last_name, age, occupation))
- print(age)
- connection.commit()
- connection.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement