import mysql.connector
# Connect to MySQL
conn = mysql.connector.connect(
    host="your_host",
    user="your_username",
    password="your_password"
)
# Create cursor
cursor = conn.cursor()
cursor.execute("DROP DATABASE IF EXISTS School")
cursor.execute("CREATE DATABASE School")
cursor.execute("USE School")
cursor.execute("CREATE TABLE student(rno INTEGER PRIMARY KEY, name VARCHAR NOT NULL, dob DATE, fee FLOAT)")
 
v=int(input("Enter number of entries:"))
for i in range(v):
  print("Entry",i+1)
  rno=int(input("Enter Roll Number:"))
  name=input("Enter Name:")
  dob=input("Enter DOB:")
  fee=float(input("Enter Fee:"))
  cursor.execute("INSERT INTO student VALUES('{}','{}','{}','{}')").format(rno,name,dob,fee)
 
cursor.execute("SELECT * FROM student")
data=cursor.fetchall()
for j in data:
  print(j)
# Close cursor and connection
cursor.close()
conn.close()

aW1wb3J0IG15c3FsLmNvbm5lY3RvcgojIENvbm5lY3QgdG8gTXlTUUwKY29ubiA9IG15c3FsLmNvbm5lY3Rvci5jb25uZWN0KAogICAgaG9zdD0ieW91cl9ob3N0IiwKICAgIHVzZXI9InlvdXJfdXNlcm5hbWUiLAogICAgcGFzc3dvcmQ9InlvdXJfcGFzc3dvcmQiCikKIyBDcmVhdGUgY3Vyc29yCmN1cnNvciA9IGNvbm4uY3Vyc29yKCkKY3Vyc29yLmV4ZWN1dGUoIkRST1AgREFUQUJBU0UgSUYgRVhJU1RTIFNjaG9vbCIpCmN1cnNvci5leGVjdXRlKCJDUkVBVEUgREFUQUJBU0UgU2Nob29sIikKY3Vyc29yLmV4ZWN1dGUoIlVTRSBTY2hvb2wiKQpjdXJzb3IuZXhlY3V0ZSgiQ1JFQVRFIFRBQkxFIHN0dWRlbnQocm5vIElOVEVHRVIgUFJJTUFSWSBLRVksIG5hbWUgVkFSQ0hBUiBOT1QgTlVMTCwgZG9iIERBVEUsIGZlZSBGTE9BVCkiKQoKdj1pbnQoaW5wdXQoIkVudGVyIG51bWJlciBvZiBlbnRyaWVzOiIpKQpmb3IgaSBpbiByYW5nZSh2KToKICBwcmludCgiRW50cnkiLGkrMSkKICBybm89aW50KGlucHV0KCJFbnRlciBSb2xsIE51bWJlcjoiKSkKICBuYW1lPWlucHV0KCJFbnRlciBOYW1lOiIpCiAgZG9iPWlucHV0KCJFbnRlciBET0I6IikKICBmZWU9ZmxvYXQoaW5wdXQoIkVudGVyIEZlZToiKSkKICBjdXJzb3IuZXhlY3V0ZSgiSU5TRVJUIElOVE8gc3R1ZGVudCBWQUxVRVMoJ3t9Jywne30nLCd7fScsJ3t9JykiKS5mb3JtYXQocm5vLG5hbWUsZG9iLGZlZSkKCmN1cnNvci5leGVjdXRlKCJTRUxFQ1QgKiBGUk9NIHN0dWRlbnQiKQpkYXRhPWN1cnNvci5mZXRjaGFsbCgpCmZvciBqIGluIGRhdGE6CiAgcHJpbnQoaikKIyBDbG9zZSBjdXJzb3IgYW5kIGNvbm5lY3Rpb24KY3Vyc29yLmNsb3NlKCkKY29ubi5jbG9zZSgp