sql database

 import sqlite3


conn=sqlite3.connect("mydatabase.db")

cursor=conn.cursor()

cursor.execute("""
CREATE TABLE IF NOT EXISTS students(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    age INTEGER
)
""")
conn.commit()
print("TABLE CREATED!!")

data=[
    ("Alice",20),
    ("Bob",22),
    ("Charlie",19),
    ("David",21),
    ("Eve",20)
]

cursor.executemany("insert into students(name,age) values(?,?)",data)
conn.commit()

print("DATA INSERTED!")

cursor.execute("select * from students")

rows=cursor.fetchall()

for r in rows:
    print(r)

print("DISPLAYED THE DATA ABOVE!")

cursor.execute("update students set age=? where age=?",(27,21))
conn.commit()


cursor.execute("select * from students")
rows=cursor.fetchall()

for r in rows:
    print(r)

print("DATA UPDATED!")

cursor.execute(
    "DELETE FROM students WHERE name=?",
    ("Bob",)
)
conn.commit()

cursor.execute("select * from students")
rows=cursor.fetchall()

for r in rows:
    print(r)

print("DATA DELETED!")


conn.close()

Comments

Post a Comment

Popular posts from this blog

Requests and Urllib

REQUESTS:- import requests # url="https://httpbin.org/post" # data={ #     "name":"hari", #     "age":21 # } # response=requests.post(url,data=data) # print(response.text) # response.status_code   # HTTP status code # response.text          # Response body as text # response.content       # Raw bytes # response.json()        # Convert JSON response to Python object # response.headers       # Response headers # GET REQUEST:- # url = "https://jsonplaceholder.typicode.com/posts/1" # response = requests.get(url) # print(response.text)  URLLIB:- import urllib . request import urllib . parse # link="https://jsonplaceholder.typicode.com/posts/2" # response=urllib.request.urlopen(link) # data=response.read() # print(data.decode("utf-8")) # print(data) # POST REQUEST:- # url="https://httpbin.org/post" # data={ #     "name":"Hari", #     "age":23 # } # encoded_data=urlli...
Read more

Python Time Zones

  from datetime import datetime from zoneinfo import ZoneInfo # UTC=Coordinated Universal Time date = datetime . now ( ZoneInfo ( "UTC" )) india_time = date . astimezone ( ZoneInfo ( "Asia/Kolkata" )) usa_time = datetime . now ( ZoneInfo ( "America/New_York" )) uk_time = datetime . now ( ZoneInfo ( "Europe/London" )) japan_time = datetime . now ( ZoneInfo ( "Asia/Tokyo" )) australia_time = datetime . now ( ZoneInfo ( "Australia/Sydney" )) germany_time = datetime . now ( ZoneInfo ( "Europe/Berlin" )) print ( usa_time ) print ( india_time ) print ( uk_time ) print ( japan_time ) print ( australia_time ) print ( germany_time ) # print(date)
Read more
  # pip install mysql-connector-python import sqlite3 conn = sqlite3 . connect ( "student.db" ) cur = conn . cursor () cur . execute (     """ CREATE TABLE IF NOT EXISTS students(     id INTEGER PRIMARY KEY,     name TEXT,     age INTEGER ) """ ) # cur.execute("INSERT INTO students(name, age) VALUES(?, ?)",("Gunjan", 21)) cur . execute ( "INSERT INTO students(name,age) values ('Gunjan',20)" ) conn . commit () cur . execute ( "SELECT * FROM students where age=20" ) rows = cur . fetchall () for r in rows :     print ( r ) # conn.commit()
Read more