SQLITE3 date -- 19/08/2026

 import sqlite3


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


cursor=conn.cursor()


cursor.execute(

    """

CREATE TABLE IF NOT EXISTS students(

    id INTEGER PRIMARY KEY,

    name TEXT,

    age INTEGER

)

"""

)


cursor.execute("insert into students(name,age) values ('Gunjan',20);")

cursor.execute("insert into students(name,age) values ('Vishal',22);")

cursor.execute("insert into students(name,age) values ('Raghu',25);")



conn.commit()


cursor.execute("SELECT * FROM students;")

val=cursor.fetchall()


print(val)

for i in val:

    print(i)



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

Strings in C Language

 // Online C compiler to run C program online #include <stdio.h> #include<string.h> #include<ctype.h> int main() {     // Write C code here     // char str[]={'G','u','n','j','a','n','\0'};     // char str[]={'G','u','n','j','a','n'};     // char str[]={"Gunjan"};     // char str[]="Gunjan";     // char str[6]="Gunjan";     // char str[5]="Gunjan"; // will throw an error     // char str[7]="Gunjan";     // char str[]="Gunjan";     // printf("%s\n",str);     char str[20];     printf("Enter the value of the string:-\n");     // scanf("%s",&str); // cannot read spaces and eliminates the string after space.     fgets(str,sizeof(str),stdin);               printf("%s",str);     str[3]='n';     printf("%c\n",str[3]);     printf("%s",str);     ...
Read more

Dictionary in Python

 thisdict = {   "brand": "Ford",   "model": "Mustang",   "year": 1964 } print(thisdict) li=dict(name="Gunjan",age=22,cnt="India") print(li) print(thisdict["brand"]) print(thisdict['model']) print(li.get("age")) print(thisdict.keys()) print(thisdict.items()) print(thisdict.values()) thisdict['year']=2004 thisdict.update({"year":2005}) thisdict['gear']="Automatic" # thisdict.pop("gear") # thisdict.popitem() # popitem method removes the last element in the dictionary # del thisdict # it throws an error instead of this we use clear method # del thisdict['gear'] thisdict.clear() # deletes all the elements in the dictionary li2=thisdict.copy() # copy is used to copy the entire dictionary for x,y in thisdict.items():     print(f"{x} = {y}") for x,y in li2.items():     print(f"{x} = {y}") if "model" in thisdict:   ...
Read more