sqlite 3 : sqlite « Database « Python Tutorial

1. Python Tutorial
2. Database
3. sqlite

import sqlite3
cxn = sqlite3.connect('sqlite_test/test')
cur = cxn.cursor()
cur.execute('CREATE TABLE users(login VARCHAR(8), uid INTEGER)')
cur.execute('INSERT INTO users VALUES("john", 100)')
cur.execute('INSERT INTO users VALUES("jane", 110)')
cur.execute('SELECT * FROM users')
for eachUser in cur.fetchall():
     print eachUser
cur.execute('DROP TABLE users')
cur.close()
cxn.commit()
cxn.close()