pythonproject-emobilis/insert.py at master · solomon-njogo/pythonproject-emobilis · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
import sqlite3
conn=sqlite3.connect('Mit-Midmorning.db')
print("open database succesfully")
conn.execute("INSERT INTO Wanfunzi(ID, NAME, AGE, SCHOOL, GENDER)VALUES (1,'ERICK',30,'eMobilis','MALE')")
conn.execute("INSERT INTO Wanfunzi(ID, NAME, AGE, SCHOOL, GENDER)VALUES (2,'SOLOMON',19,'eMobilis','MALE')")
conn.execute("INSERT INTO Wanfunzi(ID, NAME, AGE, SCHOOL, GENDER)VALUES (3,'SUSAN',29,'eMobilis','FEMALE')")
conn.execute("INSERT INTO Wanfunzi(ID, NAME, AGE, SCHOOL, GENDER)VALUES (4,'ISABEL',20,'eMobilis','FEMALE')")
conn.execute("INSERT INTO Wanfunzi(ID, NAME, AGE, SCHOOL, GENDER)VALUES (5,'JOHN',24,'eMobilis','MALE')")
conn.execute("INSERT INTO Wanfunzi(ID, NAME, AGE, SCHOOL, GENDER)VALUES (6,'STEPHEN',35,'eMobilis','MALE')")

conn.commit()
print("Recoddrs added succesfully")
conn.close()