-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsqldata.py
32 lines (25 loc) · 959 Bytes
/
sqldata.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
import sqlite3
## connect to sqllite
connection=sqlite3.connect("student.db")
##create a cursor object to insert record,create table
cursor=connection.cursor()
## 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('Henil ','Data Science','A',90)''')
cursor.execute('''Insert Into STUDENT values('John','Data Science','B',100)''')
cursor.execute('''Insert Into STUDENT values('Mukesh','Data Science','A',86)''')
cursor.execute('''Insert Into STUDENT values('Jacob','DEVOPS','A',50)''')
cursor.execute('''Insert Into STUDENT values('Dipesh','DEVOPS','A',35)''')
## Display all the records
print("The inserted records are")
data=cursor.execute('''Select * from STUDENT''')
for row in data:
print(row)
## Commit your changes in the database
connection.commit()
connection.close()