Advertisement
umaru666

Untitled

Nov 30th, 2019
218
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.57 KB | None | 0 0
  1. import sqlite3
  2.  
  3.  
  4. conn = sqlite3.connect("Animales.db")
  5.  
  6. cur = conn.cursor()
  7.  
  8.  
  9. #cur.execute("""CREATE TABLE animals(
  10.     # ani_name text,
  11.    #  ani_age  text,
  12.    #  ani_type text
  13.  
  14. #)""")
  15. print("Table has been created")
  16.  
  17. for i in range(0,2):    
  18.      name = input("Enter Name: ")
  19.      age = int(input("Enter Age: "))
  20.      jap = input("Enter Trans: ")
  21.      cur.execute("INSERT into animals(ani_name,ani_age,ani_type) VALUES(?,?,?)",(name,age,jap))
  22.  
  23. print("Data has been saved")
  24.  
  25. cur.execute("SELECT * FROM animals")
  26. print(cur.fetchall())
  27.  
  28.  
  29. conn.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement