Python Examples
19. Program to insert data into table using sqlite.
import sqlite3
conn = sqlite3.connect('student.db')
c = conn.cursor()
c.execute('''CREATE TABLE admission(rno int, name text, standard text, fee real)''')
c.execute("INSERT INTO admission VALUES (1,'Suresh','UKG',25000.00)")
conn.commit()
conn.close()
import sqlite3 conn = sqlite3.connect('student.db') c = conn.cursor() c.execute('''CREATE TABLE admission(rno int, name text, standard text, fee real)''') c.execute("INSERT INTO admission VALUES (1,'Suresh','UKG',25000.00)") conn.commit() conn.close()
Father of Python Language