Select specific column from sqlite query as specific array?

Question

I have a query similar to this:

c.execute('''select FileSize, FileName, FileType from ExampleTable
    where FileType = ?''', [FileType])
bestCRThLocal = list(c.fetchall())
print(bestCRThLocal[0]);

I want to have arrays for FileName, FileType and FileSize each own their own.

What is best way to do this in python?

alecxe · Accepted Answer · 2015-09-23 13:40:41Z

1

Use zip(). Example:

>>> l = [[1, 2, 3], [4, 5, 6],[7, 8, 9]]
>>> zip(*l)
[(1, 4, 7), (2, 5, 8), (3, 6, 9)]

answered Sep 23, 2015 at 13:40

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

Collectives™ on Stack Overflow

Select specific column from sqlite query as specific array?

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