3YASNPQN

1[] 
2     
3import sqlite3;
4
5
6conn=sqlite3.connect('employees.db');
7c=conn.cursor();
8
9
10c.execute("""CREATE TABLE employees(first text,last text,pay integer)""");
11
12
13c.execute("INSERT INTO employees VALUES('Tendo','Sinha',600000)");
14c.execute("INSERT INTO employees VALUES('Krit','Kumar',40000)");
15
16
17
18print(c.fetchall());
19
20
21
22conn.commit();
23conn.close 
24     
25[] 
26     
27import sqlite3
28
29conn = sqlite3.connect("employees.db")
30c = conn.cursor()
31
32# Create table, insert things...
33c.execute(
34    """CREATE TABLE IF NOT EXISTS employees(first text,last text,pay integer)"""
35)
36c.execute("INSERT INTO employees VALUES('Kritin','Sinha',600000)")
37c.execute("INSERT INTO employees VALUES('Krit','Kumar',40000)")
38
39# Commit the changes.
40conn.commit()
41
42# Retrieve from the table.
43c.execute("SELECT * FROM employees")
44print(c.fetchall())