GMgKe586q6suSQnyqZLlGCooeWM

Pages

Search

Sunday, March 20, 2011

Python - SQLite

To do operating with sqlite, you need
>>> import sqlite3
>>> con = sqlite3.connection('data.db')
>>> cur = con.cursor()
>>> cur.execute('''CREATE TABLE data (name TEXT, age INT, city TEXT)''')
>>> cur.execute('''INSERT INTO data VALUES('lady gaga', 24, 'luna maya')''')
>>> cur.execute('''INSERT INTO data VALUES('luna maya', 27, 'denpasar')''')
>>> cur.execute('''INSERT INTO data VALUES('barack obama', 49, 'white house')''')
>>> con.commit()
>>> cur.close()

To display it, just do
>>> cur.execute('''SELECT * FROM data''')
>>> for row in cur:
       print row
Share/Bookmark

No comments:

Post a Comment