DmgMfcZS

1# Update database 
2conn.execute("UPDATE %s set PROFILE = 'Beginner' where ID=3"%table_name) 
3conn.commit()
4
5# Delete from database 
6conn.execute("DELETE from CLIENTS where ID==2;") 
7conn.commit()
8
9import sqlite3 
10connection = sqlite3.connect("sqlite_sample.db") 
11cursor=connection.cursor()
12# create new table 
13cursor.execute("CREATE TABLE IF NOT EXISTS student (id INT, name TEXT, score INT)")
14data =[ 
15	(1, "Joey", 25), 
16	(2, "Mac", 65), 
17	(3, "Fin", 85), 
18	(4, "Jac", 45)]
19cursor.executemany("INSERT INTO student VALUES (?,?,?)",data) 
20cursor.execute("INSERT INTO student VALUES (?,?,?)", (5, "Roy", 77) )
21# commit the changes 
22connection.commit()
23cursor.execute("SELECT * FROM student") # Fetching data 
24for row in cursor: 
25	print "id: ",row[0]," name ",row[1]," score",row[2]
26print "Search example: " 
27data = ("Mac", 20) 
28cursor.execute("SELECT * FROM student WHERE name = ? AND score > ?", data) 
29for row in cursor: 
30	print "id: ",row[0]," name: ",row[1]," score: ",row[2]
31connection.close()