-
Notifications
You must be signed in to change notification settings - Fork 0
/
sql.py
37 lines (26 loc) · 1.05 KB
/
sql.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
import sqlite3
## Connectt to SQlite
connection=sqlite3.connect("student.db")
# Create a cursor object to insert record,create table
cursor=connection.cursor() #cursor is use to execute sql command
## create the table
table_info="""
Create table STUDENT(NAME VARCHAR(25),CLASS VARCHAR(25),
SECTION VARCHAR(25),MARKS INT);
"""
cursor.execute(table_info)
## Insert Some more records
cursor.execute('''Insert Into STUDENT values('Pratik','Data Science','C',90)''')
cursor.execute('''Insert Into STUDENT values('Abhishek','Data Science','B',100)''')
cursor.execute('''Insert Into STUDENT values('Aakash','Data Science','A',86)''')
cursor.execute('''Insert Into STUDENT values('Anuj','DEVOPS','C',50)''')
cursor.execute('''Insert Into STUDENT values('Harshit','DEVOPS','A',35)''')
cursor.execute('''Insert Into STUDENT values('Abhi','Cloud','C',20)''')
## Disspaly ALl the records
print("The inserted records are")
data=cursor.execute('''Select * from STUDENT''')
for row in data:
print(row)
## Commit your changes int he databse
connection.commit()
connection.close()