Fetch data from sqlite3 and save in list

Question

I would like to fetch data from a sqlite3 database and save them in a list.

conn=sqlite3.connect("words.db")
cur=conn.cursor()
cur.execute("SELECT word FROM words WHERE state='positive'")
rows=cur.fetchall()
conn.commit()
conn.close()
print(rows)

The output of rows is this:

[('abound',), ('abounds',), ('abundance',)]

I would like to have:

['abound', 'abounds', 'abundance']

I created the db with this:

cur.execute("CREATE TABLE IF NOT EXISTS words (id INTEGER PRIMARY KEY, word TEXT, meta TEXT)")

AKX · Accepted Answer · 2020-08-08 09:15:05Z

2

Just take the first column of each returned row tuple.

rows = [r[0] for r in cur]

You don't need to commit after a select either.

answered Aug 8, 2020 at 9:15

AKX

171k16 gold badges146 silver badges228 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Fetch data from sqlite3 and save in list

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related