fetchone python sqlite
#Fetches the next row of a query result set, returning a single sequence, or None when no more data is available. import sqlite3 con = sqlite3.connect(":memory:") cur = con.cursor() cur.executescript(""" create table samples( id, value ); insert into samples(id, value) values ( '123', 'abcdef' ); """) cur.execute("SELECT * from samples") print cur.fetchone() OUTPUT (u'123', u'abcdef')